Counting 7 and 8 occurances

[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?

 

[Guest]

I'd probably use a pivot table for this.

http://www.cpearson.com/excel/pivots.htm

HTH,
Barb Reinhardt

 

[T. Valko]

Try this:

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

Where n = 7 or 8 or whatever!

Biff