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?

I'd probably use a pivot table for this.

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

HTH,
Barb Reinhardt

" wrote:

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?

Try this:

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

Where n = 7 or 8 or whatever!

Biff

wrote in message
oups.com...
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?