Count Question - Similar Data

  • Thread starter Thread starter Kimmie
  • Start date Start date
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
 
If your data is in H1:H5, put the following in G1 and copy down to G5:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count function not working, keeps displaying 0 3
count unique records 14
Need help with formula to weed out duplicates 4
count nonblank cells 3
Count function 7
counta formula that doesn't count duplicates 9
Excel 2003 Counting multiple number entries in a single cell 6
Mulitiple Count of occurrences in different columns 3

Back
Top