count duplicate entries in column
 

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,


--
khilari
------------------------------------------------------------------------
khilari's Profile: http://www.excelforum.com/member.php...o&userid=33572
View this thread: http://www.excelforum.com/showthread...hreadid=533513

count duplicate entries in column
 

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.


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533513

count duplicate entries in column
 

khilari Wrote:
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


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=533513

count duplicate entries in column
 

Thanks guys.


--
khilari
------------------------------------------------------------------------
khilari's Profile: http://www.excelforum.com/member.php...o&userid=33572
View this thread: http://www.excelforum.com/showthread...hreadid=533513