How to Count the Number of Unique Values in a List in Excel : Using Excel

Toggle fullscreen Fullscreen button

Sharing buttons:

hi I'm Ted today I'm going to show you

how to count the number of unique values

in a range of cells in Excel this is

something that's very useful to do when

you have a very large data set it's a

quicker way of doing it than tediously

going through and manually counting the

individual unique values so I have a

data set here it happens to be the

members of the Baseball Hall of Fame and

what I want to do just to demonstrate

this point is to is to count the number

of unique cities these are the birth

cities of all the people in column a and

I want to focus on column G so there I'm

sure are a number of different ways of

doing this but here's a fairly foolproof

way that I want to show you the key to

it is first we want to take the column

of interest in our case the city and we

want to sort the whole data set by