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.

Count the frequency of duplicate values across a column in Excel Let us suppose a situation in which we need the number of instances where a certain value repeats in a selected list across a column.

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.

Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make quick work of this challenge.

Click the "Count" option to place a checkmark next to it. Click one of the column headers in the document that has values. The word "Count" appears in the status bar's bottom right corner.

How to Count the Number of Non-Blank Cells in Excel. Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions.

In this example, the count range is the same for each criteria set, the dates in column A. The first criteria set counts all the dates in A5:A12 that are equal to or fall after the date value in B1.