=COUNTIF(A:A,"Bob")
etc.
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"me123" wrote in
message ...
If I've got a column with lots of different values in, but they can be
repeated, eg:
Bob
Sarah
Steve
Sarah
Sarah
Bob
Jim
etc etc. Is there a way I can split them up by value and count the
number of times each value appeared, keeping in mind that the values
entered will be different all the time so I can't set a list of values
to check through, they could be anything. So say for the list above,
I'd want to get the following displayed somewhere for printing:
Bob 2
Sarah 3
Steve 1
Jim 1
Any help would be most appreciated!!
--
me123
------------------------------------------------------------------------
me123's Profile:
http://www.excelforum.com/member.php...o&userid=34312
View this thread: http://www.excelforum.com/showthread...hreadid=540776