count duplicate entries in column

**khilari** · 04-17-2006, 03:14 PM

I have an excel worksheet with only one column

the column has 65000+ entries.

most of it is duplicate
e.g. 1-823 is just "WEB ADMIN"
824 - 1562 is "WEB USER"
and so on (there are 200 of these entries)

now if i wanted to count the number of WEB ADMINS, i could count manually, but I wanted to see if these is a 'neat' way of counting those automatically.

Thanks,

**mrice** · 04-17-2006, 03:31 PM

I suggest that you use advanced filter to get a unique list of entries and then a countif function to count how many of each there are.

**Dark_Templar** · 04-17-2006, 04:11 PM

Originally Posted by khilari

I have an excel worksheet with only one column

the column has 65000+ entries.

most of it is duplicate
e.g. 1-823 is just "WEB ADMIN"
824 - 1562 is "WEB USER"
and so on (there are 200 of these entries)

now if i wanted to count the number of WEB ADMINS, i could count manually, but I wanted to see if these is a 'neat' way of counting those automatically.

Thanks,

There is,see:
http://www.cpearson.com/excel/duplicat.htm