I have a column with 29902 order numbers (none unique) and I need to
count how many appear more than 23 times. Any suggestions?

This is not a very elegant or overly efficient solution but you could use
'data'...'subtotals' to count the number of each order. (you will have to
sort the orders 1st I believe), then use conditional formatting to highlight
totals that are 23.

" wrote:

I have a column with 29902 order numbers (none unique) and I need to
count how many appear more than 23 times. Any suggestions?

Figured out an answer to my own question. I'll post it here in case
anyone cares:


=SUM(IF(FREQUENCY(B1:B29902, B1:B29902)23,1))

wrote on 14 May 2007 08:06:34 -0700:

c I have a column with 29902 order numbers (none unique) and I
c need to count how many appear more than 23 times. Any
c suggestions?
I suspect you could do this with ToolsData Analysis
Histograms and appropriate bins.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not