I maintain a record of golf scores with date & location, continually adding new data at the bottom of the table after I play another round. I want to isolate the info for my lowest 3 rounds in an adjacent table. I've used the SMALL formula to list the 3 lowest scores but how can I match each score with the corresponding date & location, even with 'duplicate' scores? e.g.. in attached file, the lowest and 2nd lowest scores are both 85. Every effort I've made, using MATCH and INDEX, results in matching '85' with the same date & location (15-Nov and 'AAA').
Bookmarks