Return the column

D

David

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,
 
N

Niek Otten

Hi Davis,

=MATCH(MAX(I38:T38,W38:AH38,AK38:AV38),38:38,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
A

Alan Beban

If you meant the column *number*, rather than the column as you posted,
then Niek Otten has supplied a formula.

Alan Beban
 
Top