Taking 3 Seperate Values Leaderboard

[Dearster]

Is there anyway I can take 3 seperate values, rank them, then output the rank in word format in a list?

So say I had 3 values 82.5%, 34.5% and 65.56% and wanted to rank them.

The cells aren't following each other however. They are on random parts of the page.

Then put them in a list as 1 Bakery, 2 Produce, 3 Fresh Foods where the name is related to the value?

Thanks.

 

[jimrward]

use the RANK function to give them a ranking, you may have to use RANK and COUNTIF to get a unique ranking

you can then use INDEX and MATCH to return them to leaderboard looking for rank=1, rank=2 etc

 

[Dearster]

Sorry is there any chance you can right out the function for me? I have really basic knowledge. Thank you

 

[Dearster]

Does anyone know a function for jimrward's example please?