Hi there - I'm a bit of an Excel newbie and I haven't managed to solve my query by looking at other forum posts. I'm probably going to describe this issue quite poorly - any help/corrections much appreciated!
I have a list - each item has an individual rating out of 10. Next to each rating I'd like a figure that gives me an idea of how good that rating is compared to all the other ratings. I think percentile is what I'm after. For example, next to one rating I could see something like 95%, which tells me that this rating is better than 95% of all the others. Or it could be 5% - meaning it's in the top 5% of all the ratings. (I'm not sure whether the percentage symbol will appear - but even something like 0.95 or 0.05 would be fine).
Am I making any sense? Thanks so much for your help!
Sorry, I cross-posted (a new concept to me - I won't do it again!) https://www.mrexcel.com/forum/excel-...lar-cells.html https://www.excelguru.ca/forums/show...-cells&p=33031
Bookmarks