Hello,
In the table below, I have a series of increasing numbers (e.g. 1-3) in column A, and my goal is to repeat this range vertically in column B up to say B500. However, if I add an extra number (in this example #4) to column A, I want column B to readjust the repeating range of cells (which I'm showing below in columns C and D). And the same if more numbers are added (or removed) in column A.
Is there a way to do this without VBA?
Thanks for any input.
In the table below, I have a series of increasing numbers (e.g. 1-3) in column A, and my goal is to repeat this range vertically in column B up to say B500. However, if I add an extra number (in this example #4) to column A, I want column B to readjust the repeating range of cells (which I'm showing below in columns C and D). And the same if more numbers are added (or removed) in column A.
1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 |
1 | 4 | 4 | |
2 | 1 | ||
3 | 2 | ||
1 | 3 | ||
2 | 4 | ||
3 | 1 | ||
1 | 2 |
Is there a way to do this without VBA?
Thanks for any input.