I have a large table that is many columns. I am trying to create a 3
column "subtable" to condense data that will find the largest values in
the third column of the main table, then return the corresponding row
values from the first two columns of the main table. I

I can't do a lookup table because I am dealing with the third column,
not the first.

I know how to use the LARGE function to return the largest values.

How do return the corresponding values from my first two columns?

I tried using something like this expression I found online, but it
doesn't seem to be appropriate or I am not making the right tweaks.

=INDEX($A$1:$B$7,LARGE(IF($A$1:$A$7=$A$10,ROW($A$1 :$A$7)),ROW(1:1)),2)

MANY THANKS FOR YOUR HELP AND THIS FORUM!!!!


--
neurotypical
------------------------------------------------------------------------
neurotypical's Profile: http://www.excelforum.com/member.php...o&userid=34719
View this thread: http://www.excelforum.com/showthread...hreadid=544848