Hi,
I have a worksheet where cell A1, B1, C1, D1, etc...(through to U1) each have a value of 1.
I need a routine that increments the value of A1, but when A1 reaches 3 it should re-set A1 to 1 and increment B1 etc....
1 1 1 1 then
2 1 1 1
3 1 1 1
1 2 1 1
2 2 1 1
3 2 1 1
1 3 1 1 etc
Probably not the best explanation ever - It's basically counting columns of units, tens, hundreds etc, but in base 3
Thanks
Bookmarks