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
|