| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column header for Max value? Index/array function?
On Thursday, December 3, 2009 3:33:01 AM UTC+4, Cecilia wrote:
Hello-- I have a series of columns for which I'm trying to find the column header for the max value. For example: A B C D E F Store 1 Store 2 Store 3 Store 4 Row 1 1 9 60 72 Store 4 Row 2 16 33 20 25 Store 2 Row 3 26 18 68 79 Store 4 I'm trying to find a formula that looks for the maximum value across a range of columns and then returns the corresponding column header for that column. The result I'm looking for is in column F. Hoping someone can help. Thanks!! Cecilia thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX function (array type) | Excel Worksheet Functions | |||
| Return column header within an array when a value is met | Excel Worksheet Functions | |||
| Help on Array and Index function | Excel Worksheet Functions | |||
| Returning an array from the INDEX function | Excel Worksheet Functions | |||
| Using INDEX function to return array row. | Excel Worksheet Functions | |||
Threaded Mode
