On Jan 23, 4:10*am, Dave Curtis
wrote:
Hi,
By using the ROW() or COLUMN() functions, it's possible to generate manyseries.
For instance, assuming you want to go down the sheet, if in cell A1 you put
=row() and copy down, you will get 1 2 3 4 5 6 7 8 9 etc.
Here are a few variations
=2*ROW() will generate 2 4 6 8 10 12 14 etc
=2*ROW()-1 will generate 1 3 5 7 9 11 13 etc
=3*ROW()-2 will generate 1 4 7 10 13 16 etc
=ROW()^2 will generate 1 4 9 16 25 36 etc
=ROUNDUP(ROW()/2,0) will generate 1 1 2 2 3 3 4 4 5 5 etc
=MOD(ROW()-1,3) will generate 0 1 2 0 1 2 0 1 2 *etc

Or are we all on the wrong track here?

Dave

Thanks Dave, just what I needed to generate 11111222223333344444....etc