RobExcel
03-18-2013, 02:50 PM
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
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