Minimum/Maximum value

[Lino]

I am trying to find the minimum and maximum value of a rolling number set consisting of 10 numbers.

example:
give me the minimum value for set 1-10
next give me the minimum value for set 2-11
next give me the minimum value for set 3-12

and so on.

Any ideas?

I am going to build a loop but I just don't know how to create the set of numbers to analyze.

Lino

[Mark W.]

On 2002-03-21 11:36, Lino wrote:
I am trying to find the minimum and maximum value of a rolling number set consisting of 10 numbers.

example:
give me the minimum value for set 1-10
next give me the minimum value for set 2-11
next give me the minimum value for set 3-12

and so on.

Any ideas?

I am going to build a loop but I just don't know how to create the set of numbers to analyze.

Lino

"and so on"? Is this an infinite loop? Is the data set infinite? If not, provide some sample data.

[Lino]

It is not an infinite data set

1,2,3,4,5,6,7,8,9,5,2,3,4,5,6,7,8,9

analyzing the above for lowest value would result in:

The first 10 (1-10) numbers = 1
The second 10 (2-11) numbers = 2

hope this helps

[Aladin Akyurek]

On 2002-03-21 11:36, Lino wrote:
I am trying to find the minimum and maximum value of a rolling number set consisting of 10 numbers.

example:
give me the minimum value for set 1-10
next give me the minimum value for set 2-11
next give me the minimum value for set 3-12

and so on.

Any ideas?

I am going to build a loop but I just don't know how to create the set of numbers to analyze.

Lino

In B1 enter:

=MIN(A1:A10)

In C1 enter:

=MAX(A1:A10

and drag down both.