MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Unique Values in a table


Posted by Andy Craig on September 26, 2001 8:30 AM

Is there a function to count the unique values in a column. I have a list of drivers and the shifts they did over a month. I need a way to work out the number of unique drivers by counting the unique entries


Posted by IML on September 26, 2001 8:42 AM

If you have a spare column, enter the formula
=COUNTIF(A1:$A$1,A1) for your first name (in A1).
copy this down as far as your list goes.

Count the number of ones with
=COUNTIF(B1:B10,1)
where the first formula was entered in B1:B1.


Good luck

Posted by Aladin Akyurek on September 26, 2001 8:48 AM

=SUM(IF(FREQUENCY(MATCH(A1:A100,A1:A100,0),MATCH(A1:A100,A1:A100,0))>0,1))

Note. The above is due to C. Pearson.

Aladin

Posted by IML on September 26, 2001 8:55 AM

That one going on my cheat sheet! very nice.