Search results

Faseeh - I replaced it with your formula and it works.. but only for one week.. do you get my point? Narayan - Could you please show me how to do it using VBA? Thanks!

Hi Faseeh, I agree that the concept is more important. The formula does show the updated status for one week.. but then I would have to have a new rating column for every new week and also new columns for every new match played, which I have to do manually. I can do that already and its...

Hi Faseeh, I understand what you are trying to do... but how would I update for the 2nd week, 3rd week, and so on, on the same column (column D) while keeping the updated rating from the previous week? In addition, your formula is "subtracting the points that should be added" and "adding the...

Hi Faseeh, I don't quite understand what you mean. The sample file is at https://docs.google.com/file/d/0B4kPRTo-4Sd2T3pwU3FNVmtQNnc/edit?usp=sharing Go through the whole thing carefully so that you would understand what I want to do. The ranking & sorting is already done. It's the...

Hi.. I am currently trying to finish a rating/ranking system for squash in excel. It has over 100 names (C13:C147) and it works fine for one direct entry for the rating (D13:D147) for each player and it gets sorted and rearranged in descending order. I want to update it every week, firstly by...