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.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

How to compare columns in Microsoft Excel As stated, we can use the Excel VLOOKUP function to find and match different data or find differences in two columns.

If one of the rows in a one-column data set contains "cat" and the other contains "Cat" in the same column, Excel considers the values to be unique.

How Can I Merge Two Columns of Data Using Microsoft Excel and Eliminate Duplicate Values?. There are two situations in which you might need to merge two columns of data in Excel 2013. If you've ...

The article, How to highlight unique values in Excel, shows two easy ways to apply conditional formatting to unique values or the row that contains a unique value. In this article, we’ll do the ...