software

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 quot;WEB ADMINquot;
824 - 1562 is quot;WEB USERquot;
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: www.excelforum.com/member.php...oamp;userid=33572
View this thread: www.excelforum.com/showthread...hreadid=533513
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: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=533513
khilari Wrote:
gt; I have an excel worksheet with only one column
gt;
gt; the column has 65000 entries.
gt;
gt; most of it is duplicate
gt; e.g. 1-823 is just quot;WEB ADMINquot;
gt; 824 - 1562 is quot;WEB USERquot;
gt; and so on (there are 200 of these entries)
gt;
gt; now if i wanted to count the number of WEB ADMINS, i could count
gt; manually, but I wanted to see if these is a 'neat' way of counting
gt; those automatically.
gt;
gt; Thanks,

There is,see:
www.cpearson.com/excel/duplicat.htm--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: www.excelforum.com/member.php...oamp;userid=33279
View this thread: www.excelforum.com/showthread...hreadid=533513
Thanks guys.--
khilari
------------------------------------------------------------------------
khilari's Profile: www.excelforum.com/member.php...oamp;userid=33572
View this thread: www.excelforum.com/showthread...hreadid=533513