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.