H
hrben
I am looking to write a formula that will tell me the columns containing the
five highest consecutive numbers in a given row that I can do a lookup
against in another spreadsheet. For example, I have a spreadsheet that
contains 15-year salary data (each year in its own column) for a group (the
first column would have the identifier of the individual). In the second
spreadsheet, I plugh in the identifier for the individual and want the
spreadsheet to automatically pull the five highest consecutive years of
salary from the other spreadsheet (each year into a row). If I use the max
or large formula in my second spreadsheet, I am only going to get one return
- and I am really looking for more of an array ...
five highest consecutive numbers in a given row that I can do a lookup
against in another spreadsheet. For example, I have a spreadsheet that
contains 15-year salary data (each year in its own column) for a group (the
first column would have the identifier of the individual). In the second
spreadsheet, I plugh in the identifier for the individual and want the
spreadsheet to automatically pull the five highest consecutive years of
salary from the other spreadsheet (each year into a row). If I use the max
or large formula in my second spreadsheet, I am only going to get one return
- and I am really looking for more of an array ...