Help :Circular References
i am trying to create a formula where the total is constantly changing
much like the the hockey standings..when you add in 2 points to the total you have a new total, but then i have to be able to use the new total to add points to is there a formula i can use that will not give me the error message Circular reference |
Help :Circular References
Just an Idea,
you will need to use 3 columns, one column called this weeks points the other called last weeks points, the third called points this week create a macro so, that, before you enter new data, cut this weeks points, and paste special to last weeks points column, then enter this weeks points in the apropriate place, formulate the point this week like this weeks points minus last weeks points, this will give you the individual player points.... well I think you get the idea, by the way, all the columns do not have to be in the viewing area, depends what kind of a pool you are working on, is it a points pool or a fantasy legue |
All times are GMT +1. The time now is 11:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com