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 count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.