Counting 7 and 8 occurances

C

calibansfolly

I've got a list of 26220 (not all unique) order numbers. Each number
appears either 7 or 8 times. I need to count how many occur 7 and how
many occur 8 times. Is there a way to do this?
 
T

T. Valko

Try this:

=SUMPRODUCT(--(COUNTIF(A1:A100,A1:A100)=n))/n

Where n = 7 or 8 or whatever!

Biff
 
Top