Return the column
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 |
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 |
Return the column
If you meant the column *number*, rather than the column as you posted,
then Niek Otten has supplied a formula. Alan Beban David wrote: 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, |
All times are GMT +1. The time now is 11:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com