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.

The syntax for counting the number of unique values from a list of a column using the array formula is as follows: Eg. Let us say we have a list of sports and the players who won at each sport.