Smallest in a range without picking same person twice

RobExcel

New member
Joined
Dec 20, 2012
Messages
2
Reaction score
0
Points
0
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
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
What are the exact results expected from this dataset? And why?
 

dond427

New member
Joined
Jan 7, 2013
Messages
13
Reaction score
0
Points
0
Nevermind. Need to work on the second half.
 
Top