Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Minimum/Maximum value

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    429
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    429
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,026
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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