Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
SEARCH EXCEL ARRAY FOR NON-VOIDS AND ENTER INTO ANOTHER ARRAY, | Excel Programming | |||
How do I resize a named array in Excel from a MxN array to a mxn . | Excel Programming | |||
Dump 5D VBA array to 2D excel array | Excel Programming | |||
Loading Excel Array from VB Array Faster | Excel Programming |