Column functions and Columns functions are Lookup and Reference functions in Microsoft Excel. The Column function returns the column number of a reference, and its formula is Column ( [reference]).

Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis ...

If you want to know how to use column index number in VLOOKUP in Excel, you’ve come to the right place. Vertical Lookup, or VLOOKUP, is one of the most popular formulas used in Excel. While the ...

We show you how to use the SUM formula in Excel, how to use the AutoSum feature and how simple additions with the plus sign work.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

If you are unable to or cannot insert Columns with right-click in an Excel spreadsheet, then read the following to set things right again.

If you want to learn how to use IF and VLOOKUP nested functions in Excel, you’ve come to the right place. The IF and VLOOKUP nested functions are two of the most powerful functions in Excel used by ...

If you want to apply a formula to an entire column in Excel, use the Fill down option, or use other great methods from this guide.

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred ...

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row.

Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be linked to the original values, meaning ...