Hi,
Looking for help with a formula... I assume a combination of Sortby, Unique, Filter...? My scenariois similar to this: I want to output a unique, sorted and filtered list of the top selling fruits in Sweden, from a table similar to this
I.e. the output I want to have from my formula is:
Thanks.
Looking for help with a formula... I assume a combination of Sortby, Unique, Filter...? My scenariois similar to this: I want to output a unique, sorted and filtered list of the top selling fruits in Sweden, from a table similar to this
A (fruit) | B (country) | C (sold quantity) |
Apple | Sweden | 10 |
Apple | Norway | 5 |
Apple | Sweden | 4 |
Pear | Sweden | 4 |
Pear | Sweden | 2 |
Pear | Norway | 8 |
Orange | Sweden | 5 |
Orange | Sweden | 25 |
Banana | Norway | 10 |
I.e. the output I want to have from my formula is:
Orange |
Apple |
Pear |
Thanks.