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      7Oranges     2Pears       0Mangoes     4I 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 7Mangoes 4Oranges 2Which then changes dynamically according to the data values in column B.But how do I then output the text value associated with this?
Print text associated with a value
google spreadsheets