Thread: Value of cell to determine range in MAX Function
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Value of cell to determine range in MAX Function
Got it!!!

=IF(MAX(INDIRECT("K"&(ROW()-1)&":K"&$Q9))+1=0,"",MAX(INDIRECT("K"&(ROW()-1)&":K"&$Q9))

Reply With QuoteReply With Quote