I have data in two columns, sorted by the second column. As follows:
A, 1 D, 2 B, 4 A, 6 B, 7 ...
I need to filter it so that the first column is unique. I.e. the value in the first column only exists once in the result.
A, 1 D, 2 B, 4
I am keeping track of scores and would like to create a "top 10" list of all of the data. I can sort the data but I have no idea how (if it is possible) to filter out everything but the personal best result from each participant.