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