Home > OS >  Google Spreadsheet MAX Join of other cells
Google Spreadsheet MAX Join of other cells

Time:05-12

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)

enter image description here

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
  • Related