In excel2007, I track a listing of golf scores, by hole, by player and would like to build a separate listing of players and the hole number where they have scored the lowest score for a given hole. For example, consider the following list:
A B C D
1 Player Hole 1 Hole 2 Hole 3
2 John 4 4 4
3 Fred 4 3 3
4 Bob 5 4 2
5 Dave 6 4 3

After all scores are entered, is there a formula I may enter in another section of the worksheet that would generate a list of those players who score the lowest on any given hole? For example, the results (based upon above table) should look like this:
G H
1 John Hole 2
2 Bob Hole 3
3

Thanks!