Thread: Return Min & Cell address
View Single Post
  #4   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


Try:

=MIN(F2:H2)&" in "&ADDRESS(2,MATCH(MIN(F2:H2),A2:H2,0),4)





Regards

Claus B.


Never ceases to amaze me, thanks, Claus.

Howard
Reply With QuoteReply With Quote