Mike H... just snooping around and stopped on this post to learn something.
This is really a neat function.

Question... when looking in the Excel help about the LARGE Function. It
explained the function but didn't go so far as to show the substitution of
Row(A1) for "k"). Where did you learn to do that?

If I wanted to find a reference book/site on the use of higher-order excel
formulas where would I start?

"Mike H" wrote:

Hi,

Here's 2 ways and both assume your data are in A1:A20.

Put this in a cell and drag down to get the 3 largest numbers
=LARGE($A$1:$A$20,ROW(A1))

Or with conditional formatting. Select the range A1:A20

and apply a conditional format of
=A1=LARGE($A$1:$A$20,1)
Set your colour

Add a second CF of
=A1=LARGE($A$1:$A$20,2)

And a third of
=A1=LARGE($A$1:$A$20,3)





--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Going Crazy with excel" wrote:

I have a column of numbers. Looking for an array formula that will identify
and highlite the "highest" three values. Does such an animal exist?