View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default 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