Auto-fill numbers in groups of 4
One way...
In A1 1000
In A2:A4 =A$1
In A5 =A1+1
Drag the formula in A5 down as necessary.
--
HTH...
Jim Thomlinson
"vtrud" wrote:
I would like to fill a column with progressive numbers in sets of 4 each.
For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so
on.
Ideas?
Thx, V
|