List question

[computerguy]

I have a list of 4 numbers. I would like to return the cell references of
the two largest values in the list. Can someone give me an Excel formula to
do that?

TIA,
GB

 

[Bob Phillips]

=ADDRESS(MATCH(MAX(A1:A4),A1:A4,0),COLUMN(A1:A4))

and

=ADDRESS(MATCH(LARGE(A1:A4,2),A1:A4,0),COLUMN(A1:A4))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[RagDyeR]

If your list was in A1 to A4, this will return the row number of the largest
value.
Copy down to return the row of the second largest:

=MATCH(LARGE($A$1:$A$4,ROW(A1)),$A$1:$A$4,0)

Is that what you're looking for?
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



I have a list of 4 numbers. I would like to return the cell references of
the two largest values in the list. Can someone give me an Excel formula to
do that?

TIA,
GB

 

[computerguy]

Thanks, it worked.

-GB