Hi
I have searched the forum for a Table Tennis Ranking spread sheet .I have attached a basic idea but with out any functions . Any wizards out there or a link to some more help would be appreciated
stan
Hi
I have searched the forum for a Table Tennis Ranking spread sheet .I have attached a basic idea but with out any functions . Any wizards out there or a link to some more help would be appreciated
stan
Hi,
This will get you the new Rankings for two players after a single match based on your criteria. I'll leave you to design a method of updating your master list of Rankings.
Hope that helps.
Regards
Hi
Thanks very much for that, I wasn't expecting a reply . I will try and get some help for the rest . thanks again for your time and effort
cheers stan
Here's how I calculated points and new rankings. I used your setup, I modified your table to only include the minimum in each range in Col A (because that's how Excel looks things up) and called the table PtSpread
The light blue cells are the only cells with formulas in them. Let me know if you have any questions.
As with XOR, the sheet doesn't automatically update the rankings in Col B. It also assumes that the higher ranked player will be in Col F and the lower ranked in Col I
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks