Gift2women
New Member
- Joined
- Jun 25, 2005
- Messages
- 33
Good day,
I don't know how much more I can take - I have been testing this for some time and cannot get past the circular reference that I cannot find. There are 2 sheets 15 and 16; 15 works fine, 16 is slightly different and gives a circular reference in P35. (These sheets are my attempt at a 3-game guarantee format for tournaments.) The same thing works on 15 that fails on 16, I cannot find anything circular about it, but Excel is quite convinced.
https://drive.google.com/drive/folders/0B_vCOj69vqdCV3Yzd2V2d1ZRb1E?usp=sharing
Not sure how to attach my file here, so i posted it to my drive ...
Changing the values in I35 & L35 (scores) should determine the value of P35 ... no luck.
Ideas?
I don't know how much more I can take - I have been testing this for some time and cannot get past the circular reference that I cannot find. There are 2 sheets 15 and 16; 15 works fine, 16 is slightly different and gives a circular reference in P35. (These sheets are my attempt at a 3-game guarantee format for tournaments.) The same thing works on 15 that fails on 16, I cannot find anything circular about it, but Excel is quite convinced.
https://drive.google.com/drive/folders/0B_vCOj69vqdCV3Yzd2V2d1ZRb1E?usp=sharing
Not sure how to attach my file here, so i posted it to my drive ...
Changing the values in I35 & L35 (scores) should determine the value of P35 ... no luck.
Ideas?
