Counting duplicate numbers
Posted by Duane Kennerson on April 18, 2001 3:33 PM
I hope I can explain this. I need excel to look at a range
of numbers and tell me how many of a certain number appears
in the range. For example:
Range A1:A5 contains the numbers 5,6,7,5,8 with one number in each
cell. I would want excel to tell me that there are 2-5's, 1-6, 1-7
and 1-8. Its basically looking at the numbers and telling
me how many of each appear in the range. Does this make sense?
If it can be done without VBA that would be preferred but I would
like any suggestions. Please help me.....