Google Sheets list key with highest value in key value pair

Question

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.

Vidar S. Ramdal · Accepted Answer · 2015-01-18 18:04:21Z

2

You need to specify a condition, not just a value, for the FILTER function.

So:

=FILTER(A2:A6, B2:B6 = MAX(B2:B6))

I have set up a demonstration spreadsheet for this, feel free to have a look or copy it.

answered Jan 18, 2015 at 17:01

Vidar S. Ramdal

17k11 gold badges68 silver badges81 bronze badges

Hey, thanks for migrating the question (I'm going to safely assume you did it) and for answering. That worked as expected. +1
– Abhishek
Jan 20, 2015 at 1:20
Nah, I didn't migrate it, I'm not often at Super User. But Google Spreadsheets questions have a pretty good chance of getting a response here at Web Applications.
– Vidar S. Ramdal
Jan 20, 2015 at 12:37

Add a comment |

1 Answer 1