Jack-P-Winner
Member
I know you can drag down formulas by placing your cursor on the lower right hand side of a cell. My question is can you write a formula in say row 100 like (=A100+ 1) and drag it up to row 1?
I will try to explain what I am trying to do and perhaps someone may be able to help and understand. Maybe think of a better way to do this. 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
that's 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
Thank you all !
I am trying to add numbers going up like the attached spread sheet
I will try to explain what I am trying to do and perhaps someone may be able to help and understand. Maybe think of a better way to do this. 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
that's 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
Thank you all !
I am trying to add numbers going up like the attached spread sheet