ExcelBanter - Counting 7 and 8 occurances

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting 7 and 8 occurances (https://www.excelbanter.com/excel-discussion-misc-queries/142057-counting-7-8-occurances.html)

[email protected]

Counting 7 and 8 occurances

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?

Barb Reinhardt

Counting 7 and 8 occurances

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?

T. Valko

Counting 7 and 8 occurances

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?

All times are GMT +1. The time now is 12:25 PM.