Thread
:
Value of cell to determine range in MAX Function
View Single Post
#
9
Posted to microsoft.public.excel.worksheet.functions
Biff
Posts: n/a
Value of cell to determine range in MAX Function
Good deal!
Biff
wrote in message
oups.com...
Got it!!!
=IF(MAX(INDIRECT("K"&(ROW()-1)&":K"&$Q9))+1=0,"",MAX(INDIRECT("K"&(ROW()-1)&":K"&$Q9))
Reply With Quote
Value of cell to determine range in MAX Function