C
calibansfolly
I have a column with 29902 order numbers (none unique) and I need to
count how many appear more than 23 times. Any suggestions?
count how many appear more than 23 times. Any suggestions?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
tim m
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.
'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.
C
calibansfolly
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))
anyone cares:
=SUM(IF(FREQUENCY(B1:B29902, B1:B29902)>23,1))
J
James Silverton
[email protected] 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 Tools>Data Analysis>
Histograms and appropriate bins.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
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 Tools>Data Analysis>
Histograms and appropriate bins.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not