Return the column
Hi Davis,
=MATCH(MAX(I38:T38,W38:AH38,AK38:AV38),38:38,0)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"David" wrote in message ...
| Hi Group,
|
| I am looking for a formula that will return the column of a min and max
| formula. I am looking across row 38 with two formulas to find both a min and
| a max value, no problem. But I would like to return the columns of min and
| max locations. The formula far the max is =MAX(I38:T38,W38:AH38,AK38:AV38)
| and returns a value, but I want the column of the location of that max value
| returned.
|
| Thanks,
| --
| David
|