How do you tie a numerical value to a name?

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm new to advanced excel writing, and have a question which I fear might be very simple. I am creating a sports rating system in excel. I have a list of names in column A, and a list of current ratings next to them in column B. What I am trying to do is have the second sheet calculate new ratings based on results. Basically, I need sheet 2 to have a column which can say "In a tournament consisting of 26 players(N), Mike from A3 played Bill from A5 and Mike won, so I need to calculate R, which is [16+(B5-B3)*2/N*(16/400)], and then add R to B3 and subtract R from B5 and print those results in sheet 2 next to both Mike's and Bill's names."

Maybe it isn't so simple, or I just am terrible at explaining things.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
1