Forum Discussion
Count of Unique Values in Column
Morning All, I'm stuck with a Problem that I'm not sure which formula will sort out, I got a Column with unique values in, now there are hundreds of these values and I don't know all of their nam...
Hi
If you enter the values to count in Column A
Then in Column C, create the following function in C2 and copy it down:
=A1&" = "&COUNTIF($A$1:$A$9,A1)
Then
To remove duplicates, select the functions in column C (C1:C9) >> Data Tab >> remove duplicates >> OK
Hope that helps
Nabil Mourad