"Harlan Grove" skrev i en meddelelse
oups.com...
Leo Heuser wrote...
"Harlan Grove" skrev i en meddelelse
That so, how could you believe the formula construct

D2:
=MAX(Rng)

D3 and down:
=LARGE(Rng,SUMPRODUCT(COUNTIF(Rng,$D$2:D2))+1)

would be as efficient as

D2:
=MAX(Rng)

D3 and down [array formulas]:
=MAX(IF(Rng<D2,Rng))
....
I'm not talking efficiency, but sometimes it's not possible
for the user to sort the list (or place it in descending order
as you put it). That's where my formula does the job.

I understood your

"Much more efficient is listing them in descending order. If the first,
the MAX, were in cell E1, try the following formulas"

as if the user was to put his *datacolumn* in descending order.
I now see, that you are talking about the *result* list, so you are
right. My mistake, and my formula is inferior.