Count Question - Similar Data

K

Kimmie

So with this formula and example the answer is 5; however, is there a way to
use a formula to count similiar data. For instance,

Rec 21 will have a count of 2 in the next column because it appears twice.
Rec 24 will have a count of 1 in the next column because it only appears once.

Thanks for your assistance!


Awesome! Thanks
 
G

Glenn

If your data is in H1:H5, put the following in G1 and copy down to G5:

=COUNTIF($H$1:$H$5,H1)
 
Top