On Mar 7, 9:36 pm, Joel wrote:
The LARGE function does the job

=large(a1:A4,5) where 5 would be the 5th largestt number

" wrote:
Hello,

I need a bit of help with what maybe a very simple task.

I have three columns of data (A B C). I need to locate the 3 rows
containing the highest value in column C and then return the
corresponding values in Columns A and B. I would like the high values
and the corresponding values from A and B printed in an adjacent
column (E and F and G). Actually, the location of the final values is
unimportant. Any advice or help anyone could give would be MUCH
APPRECIATED!!

For example:

A B C D E F G
3 5 3
35 42 13
34 15 95
35 1 46
94 42 94
High A_Val B_Val
95 34 15
94 94 42
46 35 1

Thank you much,

Aaron

Sorry, I forgot to specify that the values in Column C are the only
values for which the 'high' value is relevant. In the real application
of this search the values in Columns A and B will be text and the
values in C will be the only numeric values for which the selection
can be based upon.

Thank you so much for your response.

Aaron