Quote:
Originally Posted by zvkmpw
Just wrap MAX() around it:
=MAX(OFFSET(Data!$M$1,'Trend 1'!$W$1,,'Trend 1'!$Y$1))
When OFFSET() returns a range, it can be used as a parameter in a function that expects a range, like MAX or AVERAGE.
|
Shot zvkmpw, i did try that but it did not work previously. it appears that there was a issue with the formula that made up the range part of the offset.
Sorted now and working.
i thought that it could not be complicated, got to love them formulae, works for one thing but not another :
Similar Threads
Hybrid Mode
