Thread: Max function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Max function
Assume your data in columnA

="A"&MATCH(MAX(A:A),A:A,0)


"DianeG" wrote:

Is there any way when obtaining a result for the Max function that you can
display which cell it refers to?

Thanks

Diane
Reply With QuoteReply With Quote