Hey,

I'm looking for the right function that will look through a range and
tell me how many times it sees a particular non-numerical value.

For instance say I have these names in a column:

John
Ted
Andrew
John


The function would go through and count all the values for me and give
me this:


Total John: 2
Total Ted: 1
Total Andrew: 1

This would make it so I don't have to count each instance by myself.

Can excel do this?

Thanks

-osmosys


--
osmosys
------------------------------------------------------------------------
osmosys's Profile: http://www.excelforum.com/member.php...o&userid=34952
View this thread: http://www.excelforum.com/showthread...hreadid=546819