Value of cell to determine range in MAX Function
This is what I would have thought was correct (cell is K9) but I just
keep on getting an "Invalid Cell Reference" error.
=MAX(INDIRECT(K8&":K"&Q9))
When I Evaluate the formula it equates to:
=MAX(INDIRECT(";K5))
Seems strange that it contains a colon.
|