Formula for transferring numbers from one column to a different column in ascending order

To all,

Brand new here to I'm sorry for the possible silly questions to follow.

I have built a spreadsheet for a British Open Golf Pool at my work. I need to figure out a way to transfer the information in the "Total" column (E Column) of my table in to the "Rankings" column (I Column) in ascending order. Each day of the golf tournament I will be changing the data in column E so a simple copy and paste is obviously not an option. Ideally, the corresponding team Name from Column B would transfer over as well perhaps to Column H but that might be too much to ask at the moment. My number ranges are from E3:E556 but there are only 70 filled numbers in that range due to the formatting.

I hope this makes sense and that someone can help, I'm obviously lost! THanks so much guys and I have attached the file for further confirmation as it is a little hard to describe exactly what I have going on!

Chemist,

Thanks so much for your prompt reply. I tried both copying that formula and manually entering it but an error code continued to pop up that the "name is not valid". I made sure to take out any spaces. Any recommendations?

Is this what you're looking for? It's a kind of messy solution with quite a few hidden helper columns but it does return the correct ranking.

British Open Pool Entries.xlsx

I've gone for a similar solution to ChemistB it seems, but I've assumed that if you have 3 people in 2nd place for example, the one after would be 3rd place.

wow guys, thank you so much. This is way advanced stuff that I have been trying to figure out on youtube. Ya'll are amazing! Makes my life so much easier and Works like a charm!

If I can be extra greedy and ask another question, no worries if you guys don't wanna do this cuz you've already helped more than you know. On my second sheet with my players table. I am manually inputting the scores after each day. How do I create a formula to have those numbers transfer to the corresponding names on the first sheet? So when I input Tiger Woods' score in sheet 2, his score will pop into sheet 1 column D "Scores" wherever his name is typed in?

THANK YOU!!!!

Chemist you are the man! I converted the information into a Table named "Table" and checked all the spellings and scores. I went in to the Scores column to enter the formula and for some reason it still gives me the error code. I tried a few things to manipulate the formula but I don't know if it is because of my excel version or what.

Sorry to be such a pain!

Absolutely, I put the formula in the first spot in SCORES in Entries - Table 1.

Chemist thanks again for your help. Took your advice, made sure there were headers and renamed the table "Results". After looking in the formula helper it suggested adding the quotes =VLOOKUP("[@Players]",Results,2,FALSE) The system now takes the formula but spits out a #N/A into the cell.

I don't know if I am just excel handicapped or what but i can't get it to work. I went through the help section and looked online also after following your instructions. You've taken a lot of time to help me and I really appreciate it. Is it possible for you to go in there and try to fix it and attach the file for me? Sorry Chemist I just can't get it to work!

Thanks a million Chemist!! Hopefully I can start to gain a little more knowledge for the future from what you've provided me with. Have a good weekend!