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.