Forum Discussion
Solved
Continue series of similar numbers
Hello, I want to continue series of similar numbers. Sow, 1111, 2222, 3333, etc.
How can I do this?
Bremzki Try the attached file.
8 Replies
Bremzki Would the pattern be to always add 1111 to the previous cell? If so, enter 1111 in, for example, cell A1. Then, in A2 enter the formula =A1+1111 drag it down as long as you want.
But just to be sure, what would be the cell following 9999? The above formula will return 11110. I you would want anything else (perhaps 10101010 or 0000) that would be something else.
- Riny_van_Eekelen, thanks for the fast reply. I guess my description wasn't clear enough. What I mean is in A1 1, A2 1, A3 1, A4 1, A5 2, A6 2, A7 2, A8 2, A9 3, etc. So in four underlaying cells the same number and the four underneath +1.
Bremzki Perhaps like in the picture below?
