This formula will count duplicates in a list. If you have a list that says:
eggs
eggs
beef
beef
beef
chicken
the formula will return:
2
2
3
3
3
1
because thats the number of instances of each unique item.
here's the formula:
=COUNTIF($A$1:$A$10,$A$1:$A$10&"")
but i can't figure out HOW this works. can someone explain it please? Thanks!!!
eggs
eggs
beef
beef
beef
chicken
the formula will return:
2
2
3
3
3
1
because thats the number of instances of each unique item.
here's the formula:
=COUNTIF($A$1:$A$10,$A$1:$A$10&"")
but i can't figure out HOW this works. can someone explain it please? Thanks!!!