How do you tie a numerical value to a name?

Closed
Clawless - Aug 13, 2010 at 02:05 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:31 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 17, 2010 at 11:31 PM
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