I have a list of names, all with a certain score attributed to them. I would like to, on a separate worksheet, rank these names by their score but have the formula input their name instead of 1st, 2nd, 3rd, etc. Now it sounds simple, but the position these names are ranked will be changing constantly, and I need the formula to automatically reposition them properly in the rank, while keeping the same name showing.

I've read a couple threads somewhat like this, but none of them really answered my question. Also, I've read a few threads where providing a sample workbook was requested. I have no idea how to do this. If it would help, let me know how to do it or point me in the right direction to find out how to do it.

Thanks!