Hi

I am trying to return the max value that is part of a offset range.

Basically i have a name range that i use for trending and i want to find the highest value of that trend.

=OFFSET(Data!$M$1,'Trend 1'!$W$1,,'Trend 1'!$Y$1)

$W$1 refers to where my trend will start.
$Y$1 refers to how many row to include in the trend.

the trend works great. the problem is that there are a large number of data points. i would therefore like to display the highest value from the offset range.

Any assistance will be greatly appreciated.