I'm using this formula to sum how many times a unique order number
appears in column A:
=SUM(IF(FREQUENCY(A1:A36533,A1:A36533)=N,1))

where N is the number of times it appears.

There is one order that appears six times and I need to find out what
that order number is. Any suggestions?

If it is the most common item then:

MODE(A1:A36533)

will do it

Mike

" wrote:

I'm using this formula to sum how many times a unique order number
appears in column A:
=SUM(IF(FREQUENCY(A1:A36533,A1:A36533)=N,1))

where N is the number of times it appears.

There is one order that appears six times and I need to find out what
that order number is. Any suggestions?

On May 21, 1:55 pm, Mike H wrote:
If it is the most common item then:

MODE(A1:A36533)

will do it

Mike


It's the least

Try this

=INDEX(A2:A30,MATCH(MIN(COUNTIF(A2:A30,A2:A30)),CO UNTIF(A2:A30,A2:A30),0))

entered with ctrl + shift & enter

will return the least occurring value in A2:A30

note that array formulas tend to slow down large spreadsheets considerably


--
Regards,

Peo Sjoblom

wrote in message
ups.com...
On May 21, 1:55 pm, Mike H wrote:
If it is the most common item then:

MODE(A1:A36533)

will do it

Mike


It's the least