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.

If you are unfamiliar with inputting formulas into Microsoft Excel, the much simpler way to get the number of unique values in an Excel column is through a filter.

How to Randomize the Contents of a Column in Excel. Suppose you have an Excel spreadsheet with a single column A and 52 rows. The value in each row's cell represents a playing card, for example K ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

How to use Excel formulas to compare multi-column lists Your email has been sent Duplicates in the same column are easy to find by sorting, filtering, and using conditional formatting. When none ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

You can reverse the row or column order of a list in Excel by creating reference list, a Macro, and using INDEX function. We have explained all these methods.