I have a Google Sheet that collects data and analyses any trends. What I'm trying to do is figure out how to output the text value associated with the numerical value.
Example:
Apples 7
Oranges 2
Pears 0
Mangoes 4
I grab the highest values by doing the following..
= LARGE(B:B, 1)
= LARGE(B:B, 2)
= LARGE(B:B, 3)
My desired output would look like..
Top 3
-------
Apples 7
Mangoes 4
Oranges 2
Which then changes dynamically according to the data values in column B.
But how do I then output the text value associated with this?