Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column header for Max value? Index/array function?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column header for Max value? Index/array function?
Try this...
=INDEX(B$1:E$1,MATCH(MAX(B2:E2),B2:E2,0)) Copy down as needed. -- Biff Microsoft Excel MVP "Cecilia" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column header for Max value? Index/array function?
=INDEX($B$1:$E$1,MATCH(MAX(B2:E2),B2:E2,0))
"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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column header for Max value? Index/array function?
In cell F1 apply the below formula and copy down as required
="Store " & MATCH(MAX(B1:E1),B1:E1,0) -- Jacob "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column header for Max value? Index/array function?
On Thursday, December 3, 2009 5:03:01 AM UTC+5:30, 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 2Row 3 26 18 68 79 Store 4I'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 Valko.... It is working fine. Regards, balaji |
#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 |
Reply |
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 |