Counting Counters Up

[larbec]

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

 

[larbec]

For Ice

Ice,

I tried emailing you with an e it came back. I used the e after the word forums. I'm sure I did something wrong oh wait, that's what my wife says lol

 

[Icewynd]

Sorry,

I guess I was too obscure as I tried to outwit the spam bots cruising the web.

icewynde at (g)ooglemail

Good luck!

 

[larbec]

Lol gotcha

 

[Icewynd]

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

OK, now I am really confused!

I assume that these are similar to your other spreadsheet, i.e each column is independent of the others. That is, these are not numbers where 1,336 would be followed by 1,337, 1,338, 1,339, 1340.

So 1234 can be 1334 or 1235

I'm not sure what this is about and I can't see it in your spreadsheet. I'm guessing that only the second or last digit can vary? 1234 can become 1334 or 1235, but not 2234 or 1244? Am I getting a glimmer of light?

Good luck!