Forum Discussion
Return a value from column adjacent to query
I have a very simple table with a name column and a number column. https://www.baseball-reference.com/players/c/crawfsa01.shtml 16 https://www.baseball-reference.com/players/l/lajoina01.shtml...
Some more recent options:
= TAKE(SORTBY(Name, Number, -1), 1)gives just the name, whilst
= TAKE(SORT(simpleTable, 2, -1), 1)gives both the maximum value and the associated name.