Programatically find Min and Max values

[Lino]

I am trying to programatically find the minimum and maximum values in a rolling array of data.

Example:

let's say the first range is A1:A10
the second A2:A11 and so on...

For Each Array of 10 values find Maximum value

Next Array

Thanks

 

[Aladin Akyurek]

On 2002-04-04 11:04, Lino wrote:
I am trying to programatically find the minimum and maximum values in a rolling array of data.

Example:

let's say the first range is A1:A10
the second A2:A11 and so on...

For Each Array of 10 values find Maximum value

Next Array

Thanks

In B1 enter and copy down:

=IF(ROW()>$E$1,MAX(OFFSET(A1,0,0,-$E$1,1)),"")

where E1 houses the condition, that is, your 10.

Aladin