Ive got a Spreadsheet like this: I cant figure out how to DYNAMICLY search for this:
I want to find the MAX Score Value output the related name (No worries, in another coloumn ive got the Score calculated as clean numbers without letters) (QUERY doesnt really work because once I change a score, it doesnt update that output)
CodePudding user response:
use:
=SORTN(SORT({x2:x, y2:y}, 2, 0), 9^9, 2, 1, 1)
where:
x2:x - column with names
y2:y - column with values
2 - sort values
0 - in descending order
9^9 - return all rows
2 - 2nd mode of sortn eg. group by
1 - names column
1 - in ascending order