Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup type formula
If I have an array of data and in Col J I have salaries, and col I have
names, how can I express a formula somewhere else, say cell R10, I want to look through the salaries, find the highest, and identify the person with that salary I'm thinking some way of identifying the row that has the highest value in a column and use that as an offset from $I$1 but am not sure how to do that properly cheers! L |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup type formula
One way, assuming no ties in highest salary in col J
Put in R10: =INDEX(I:I,MATCH(MAX(J:J),J:J,0)) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Lee Harris" wrote in message ... If I have an array of data and in Col J I have salaries, and col I have names, how can I express a formula somewhere else, say cell R10, I want to look through the salaries, find the highest, and identify the person with that salary I'm thinking some way of identifying the row that has the highest value in a column and use that as an offset from $I$1 but am not sure how to do that properly cheers! L |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to type correctly formula in calculated field in a pivot? | Excel Worksheet Functions | |||
formula to lookup table in another Worksheet please | Excel Worksheet Functions | |||
vba 97 excel lookup formula | Excel Discussion (Misc queries) | |||
Multiple lookup in a single formula .. | Excel Worksheet Functions | |||
Conversion lookup formula | Excel Worksheet Functions |