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
where the first formula was entered in B1:B1.

Good luck

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


Note. The above is due to C. Pearson.


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

That one going on my cheat sheet! very nice.