View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] junkmail115@gmail.com is offline
external usenet poster
 
Posts: 2
Default Help with Excel Array?

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