I am trying to copy or mimic what is happening in 4 other columns and perhaps 30 rows. I have what I call 4 digit counters that always count up
If you look at a column that go vertically full of E's and Os or Us and Ds I want to be able to put say 2 rows of numbers 1111 1111
And click a button and it takes off from the top 1111 and runs itself Once you understand how the counters advance up the program should be easier to understand. I "DO" need the CF for the color (red/yellow, green/gray) There is always an even amount of vertical cells (2-4-6-8-10....) so if you start with the 1111 and the next row up is E you would advance one of the first row 1's to either 2111 or 1211. Then if the next is An E and you had 2111 you couldn't advance the 1st digit because the 2 will go to 3 making it an Odd amount of cells (1) you would have to get the 2nd digit to change to a 2. After a few rows up its obvious which way it will go. Starting out you may always have a odd set of rows. This is what it would look like
3111
2111. This is wrong
1111
2211
2111. This is correct
Here is a sample spreadsheet and video I made explaining how it works.
https://app.box.com/s/uxrmbe7d70b2kq7ttm7e
I do have it poste n here s well
http://www.ozgrid.com/forum/showthread.php?t=188859&page=2&p=716202#post716202
If you look at a column that go vertically full of E's and Os or Us and Ds I want to be able to put say 2 rows of numbers 1111 1111
And click a button and it takes off from the top 1111 and runs itself Once you understand how the counters advance up the program should be easier to understand. I "DO" need the CF for the color (red/yellow, green/gray) There is always an even amount of vertical cells (2-4-6-8-10....) so if you start with the 1111 and the next row up is E you would advance one of the first row 1's to either 2111 or 1211. Then if the next is An E and you had 2111 you couldn't advance the 1st digit because the 2 will go to 3 making it an Odd amount of cells (1) you would have to get the 2nd digit to change to a 2. After a few rows up its obvious which way it will go. Starting out you may always have a odd set of rows. This is what it would look like
3111
2111. This is wrong
1111
2211
2111. This is correct
Here is a sample spreadsheet and video I made explaining how it works.
https://app.box.com/s/uxrmbe7d70b2kq7ttm7e
I do have it poste n here s well
http://www.ozgrid.com/forum/showthread.php?t=188859&page=2&p=716202#post716202
Attachments
Last edited: