I have a some data in key-value pairs setup like so:
A B
1 Key: Value:
2 Cars 5
3 Bikes 4
4 Vans 9
5 Trucks 6
What I can't seem to figure out (mind-block) is the formula to answer this:
Product with higest sales: <answer should be 'Vans'>
What formula would I need to get the result Vans
? I've tried this:
=FILTER(A2:A6, MAX(B2:B6))
To which I get an error stating that the Fliter has mismatched array sizes.