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

Thread: Programatically find Min and Max values

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

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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

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
  •