I have two numeric columns, A and B. I want to find the max value in column B, which will return multiple rows. Then I want to find the max value in column A from among these rows.
A B 5 315 7 315 10 275
The function should return:
It would be fine if this were a combination of two functions - one that finds the max value in B (315), and another that finds the corresponding max value in A (7). That's how I'm trying it right now using:
But this solution only finds the latest row that has column B's max value:
Someone suggested I use the query function, but I couldn't get that to work either.