In the first cell of the list, enter your starting number, e.g., 1000.
Then, in the cell below that, enter
=$A$5+TRUNC((ROW()-ROW($A$5))/4,0)
Change $A$5 to the reference to the first cell in which you entered
1000. Then, copy this formula down for as many rows as you need.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
On Fri, 25 Sep 2009 11:31:02 -0700, 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