Thread: Finding location (or start cell) of highest consecutive values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cimjet[_4_] Cimjet[_4_] is offline
external usenet poster
  
Posts: 29
Default Finding location (or start cell) of highest consecutive values
Also this would take you to it.
=HYPERLINK("#G"&MATCH(MAX(G1:G50380),G1:G50380,0), "GOTO:")
Reply With QuoteReply With Quote