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.
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?