View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
vtrud vtrud is offline
external usenet poster
 
Posts: 21
Default Auto-fill numbers in groups of 4

Chip,
You are my most favorite person in the world right now! Thank you!!!!
Vicki

"Chip Pearson" wrote:

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