Excel 2007 : Rank players

[throary]

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