A common function many people use is the COUNTIF function and that will count any value you choose.
In the example above, we counted every cell in Column A that said “Joe” with =COUNTIF(“A1:A10,”Joe”) . It was 3.
But there isn’t one function to count unique values. But we can make an array formula with 2 functions to do this. We start off with this : =SUM(1/COUNTIF(A1:A10,A1:A10))
But then instead of pressing Enter you press CTRL – SHIFT – ENTER
What this does is to make the function an array. You need to do this step or else the formula won’t work.
You will get the following when you do that:
It shows 7 uniques in that range which is correct.
This is a very cool way to get unique values without doing any pivot table or adding any helper columns to find this out. I hope you liked it.