Google Sheets – Filter High Score List for Personal Bests

google sheets

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.

Best Answer

For the first column, in column D for example, use the following formula:

=UNIQUE(A1:A5)

and the second column, in column E for example:

=ARRAYFORMULA(IFERROR(VLOOKUP(D:D;A:B;{2}*SIGN(ROW(A:A));0),""))
Related Topic