Column header for Max value? Index/array function?

C

Cecilia

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
 
J

Jacob Skaria

In cell F1 apply the below formula and copy down as required

="Store " & MATCH(MAX(B1:E1),B1:E1,0)
 
M

mrpbala

Hello--I have a series of columns for which I'm trying to find the columnheader 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 acrossa 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
Click to expand...

Thanks Valko.... It is working fine.
Regards,
balaji
 
B

bijuthomas73

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
Click to expand...

thanks
 
Top