Thread: Finding location (or start cell) of highest consecutive values
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emilio Guerra Emilio Guerra is offline
external usenet poster
  
Posts: 6
Default Finding location (or start cell) of highest consecutive values
On Friday, January 24, 2014 10:22:18 AM UTC-5, Cimjet wrote:
Also this would take you to it.

=HYPERLINK("#G"&MATCH(MAX(G1:G50380),G1:G50380,0), "GOTO:")

Thanks, Cimjet, but that doesn't seem to work with my formula. You gave me a formula that finds the MAX value, but I had a FREQUENCY in there too.

=MAX(FREQUENCY(IF(G2:G50380<32.1,ROW(G2:G50380)),I F(G2:G50380=32.1,ROW(G2:G50380))))


Am I missing something?
Reply With QuoteReply With Quote