I was wondering if there's a way to use a function (maybe Filter?) in order to sort this data such that column K only contains one of each number, and the highest test associated with it in column L. Here's an example that I created manually using a small section of data.
For example, the highest test associated with the number 9 is test 11, so the function should return only one entry containing 9, and then the highest test (test11) in the cell next to it. I feel this should be fairly easy using a filter function but I cant quite get it to work. Thanks for any help!
Link to sample spreadsheet:
https://docs.google.com/spreadsheets/d/1WqDaiNK-capSjp0l1-vJDJH30Z4pjA74y1U5M7c7BmQ/edit?usp=sharing