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