Thanks for the tip Charlie,
I'm still on my Linux/OOo/calc box I'm afraid. My Windows/Excel laptop is still at the repairers waiting for a new LCD screen to come from Japan or China or wherever. Est another 3 weeks. So I can't find that tool in OOo, but I have been using the Trace Error/Fault/Precedent in OOo/calc. Probably not the same!
As it is, I still can't determine what is giving me the errors, which leaves me unsure if I'm chasing an OOo compatibility issue or something else. I have discovered that the errors are related to whether the spreadsheet is being used to enter data or has been saved/closed/re-opened.
This seems to be my first hurdle that I've been trying to explain and that I have been trying to find a solution for with your kind explanation of the formula. I need to get over this one, but I'm stumped at the moment and as I say, I'm also not sure if it is something I did wrong when I followed your instructions to enter the remaining referenced data.
What I am finding is, if I change the number of teams, I get the errors/problems below. If I save/close the spreadsheet (still in the error state) and then re-open it the errors are gone.
Sorry the following is a long list, but it is only to show an overview of the problem:-
Say I have just opened the spreadsheet and the last time it was saved I had entered 6 for the number of teams, then the formula produces (correctly) the following:-
If I now change the number of teams to another number (4 in this example), I get the #VALUE! instead of the date:-
Another example with changing the number of teams to 10 is still #VALUE! errors (scroll down the list) and some dates/errors blank:-
Bookmarks