+ Reply to Thread
Results 1 to 3 of 3

find minimum value for each range of numbers in a table

  1. #1
    Registered User
    Join Date
    05-12-2008
    Posts
    2

    find minimum value for each range of numbers in a table

    In column B I have a range of values and in column A a "1" is against the first few values and 2 against the next few, then 3 against the next few and so on. The number of values against 1, or 2 or 3 is variable with no pattern. How can I return a minimum value from each of the ranges of values against 1,2 and 3 respectively in a third column in the same row as the first 1, 2 or 3 in column A respectively?
    A B C
    1 1 50 = min value of '1' values
    2 1 40
    3 1 60
    4 1 30
    5 2 20 =min value of '2' values
    6 2 10
    7 2 30
    8 3 50 =min value of '3' values
    9 3 60
    10 3 70
    11 3 80
    12 3 100
    13 3 10
    Thank you

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try in C2, copied down:

    Please Login or Register  to view this content.
    Adjust the ranges in the Min(IF()) part to suit and then you must confirm the formula with the CTRL+SHIFT+ENTER keys not just ENTER. You will see {} brackets around the formula.

    Note: this formula will show the min value beside the first occurance of the repeat number... if you want it to show on every row, then remove the Countif() part of the formula.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    05-12-2008
    Posts
    2

    Thumbs up

    Thank you.That works great

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1