Thanks:  0
Likes:  0

1. 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

2. 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.

3. 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

4. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•