count duplicate entries in column

[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 coun
manually, but I wanted to see if these is a 'neat' way of countin
those automatically.

Thanks

 

[mrice]

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]

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

 

[khilari]

Thanks guys.