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
|