I know this one may be a challenge , it is for me but still going to try some =to's
I will try to explain this a little different and perhaps someone may be able to help and understand better. The counters work always going up in numbers and never having a 0 (zero) so after a 9 it starts over again at 1 123456789. 12345789 they work every other digit "up"
1334
1234
or
1235
1234
So 1234 can be 1334 or 1235
thats one scenario
the other
2234
1234
1244
1234
1234 can be 2234 or 1244
it works like this forever and ever. I'm wanting to be able to build up to perhaps 20 different patterns going up perhaps 10 rows. But what this really means is every time I get a new number they split and double. So, the 1st number becomes 2 like the scenario above. Now you can see I have 4 new numbers to go up 1334 and 1235 and then the other set 2234 and 1244. These two sets will become 8. I have done a few in the attached spreadsheet. The conditional formatting is important. Again all even numbers are Green font with gray shade, Odd are red font with yellow shade
This will definitely help me plus save me ALOT of time and potential of making mistakes that somehow happen
Thank you all !
https://www.dropbox.com/s/gr9n4s9laahri5c/counters%20split%20and%20go%20up.xlsx
I will try to explain this a little different and perhaps someone may be able to help and understand better. The counters work always going up in numbers and never having a 0 (zero) so after a 9 it starts over again at 1 123456789. 12345789 they work every other digit "up"
1334
1234
or
1235
1234
So 1234 can be 1334 or 1235
thats one scenario
the other
2234
1234
1244
1234
1234 can be 2234 or 1244
it works like this forever and ever. I'm wanting to be able to build up to perhaps 20 different patterns going up perhaps 10 rows. But what this really means is every time I get a new number they split and double. So, the 1st number becomes 2 like the scenario above. Now you can see I have 4 new numbers to go up 1334 and 1235 and then the other set 2234 and 1244. These two sets will become 8. I have done a few in the attached spreadsheet. The conditional formatting is important. Again all even numbers are Green font with gray shade, Odd are red font with yellow shade
This will definitely help me plus save me ALOT of time and potential of making mistakes that somehow happen
Thank you all !
https://www.dropbox.com/s/gr9n4s9laahri5c/counters%20split%20and%20go%20up.xlsx