Excel 2007 : Rank players

**throary** · 02-10-2012, 02:23 PM

Hello!

I am currently doing a elo ranking list for a sport called racketlon. Elo is a ranking system used mostly in chess but even other sports.

Now to the problem...

I want the players listed in the A column to have their current rating in the B column. The current rating is listed for each player at the bottom of the W-BW column but there will be more players later and also more games that I will put in so this rowline will change.

See the attatched file, hopefully you know how to do it and what I mean

Thanks Daniel

**FDibbins** · 02-10-2012, 09:18 PM

I have added a helper column at W. Moving forward, just increase this by 1 when you add additional rows.

Column B has a formula which looks into the data and returns the value from the last row for each name. To test accuracy, I referenced the last row for a few names in column C.

An option to eliminate having to update the formulas each time you add a new row of data would be increase the formula range by 2 rows, then when you add more data, "insert" a new row to add the data to, that way the formulas will include the new rows.