Repeating number sequence in a column
Is there a way to automatically set up a repeating number sequence in a
column? I've figured out how to do it with sequences of up to 7 numbers using
nested "IF" formulas in a macro, but as I understand it, that's as many
nested formulas as Excel can handle. I'd need repeating sequences up to three
digits in some cases.
Thanks!
|