Results 1 to 5 of 5

Thread: Smallest in a range without picking same person twice

  1. #1

    Smallest in a range without picking same person twice



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have two columns as below below I need to find the lowest value from each person First score and they find the lowest value of the second score without including the second value of the person of which we used their first value.
    Name Score
    Fred 5
    Fred 4
    Joe 4
    Joe 3
    Mary 6
    Mary 5
    Sue 5
    Sue 3

    In the example about, I would want to pick Mary's score of 3, then look that the other scores and not pick Mary's score of 5. ie I would pick Joe's score of 4

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,464
    Articles
    0
    Excel Version
    Excel 2016
    What are the exact results expected from this dataset? And why?


  3. #3
    Nevermind. Need to work on the second half.

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,464
    Articles
    0
    Excel Version
    Excel 2016
    Are you the same person as OP?


  5. #5
    Me? Nope.

Posting Permissions

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