Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find Max value within a Offset
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Max value within a Offset
I am trying to return the max value that is part of a offset range.
=OFFSET(Data!$M$1,'Trend 1'!$W$1,,'Trend 1'!$Y$1) 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. |
#3
|
|||
|
|||
Quote:
Sorted now and working. i thought that it could not be complicated, got to love them formulae, works for one thing but not another : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value then offset, to set variables | Excel Programming | |||
find max value in column and return offset of that value | Excel Discussion (Misc queries) | |||
Find Selected value to .Offset from | Excel Programming | |||
Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming | |||
Find then offset. | Excel Worksheet Functions |