View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default Return Min & Cell address

Can this be done to return the MIN of F2, G2 or H2 and and "F", "G" or "H" which ever is the MIN?

Where F2=1, G2=2, F2=3.

This returns 1 FALSE.

=MIN(F2:H2)&" "&IF(ADDRESS(2,6)=MIN(F2:H2),"F",IF(ADDRESS(2,7)=M IN(F2:H2),"G",IF(ADDRESS(2,8)=MIN(F2:H2),"H")))

Thanks.
Howard