List question

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

=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)

"computerguy" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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!
=====================================================



"computerguy" <[email protected]> wrote in message
news:[email protected]...
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

Thanks, it worked.

-GB

"RagDyeR" <[email protected]> wrote in message
news:[email protected]...
> 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!
> =====================================================
>
>
>
> "computerguy" <[email protected]> wrote in message
> news:[email protected]...
> 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
>
>
>