Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Clueless
 
Posts: n/a
Default How do I create a list of sequential numbers using Excel or Acces.

I am trying to generate a list of numbers, incrementally increased to my
specifications. I absolutely hate the idea of having to do these
myself....is there a way to have Excel or Access generate this list for me?
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

There are all kinds of ways of doing this, but what are your
specifications, and restrictions.

Increment by one
insert a 1 into cell A1 or a formula =ROW() into cell A1

place 1 into cell A1, drag down with right mouse button, fill series

place =ROW() * 5 - 1 into cell A1
drag down with mouse, or
drag down with right mouse button, fill values (still be formulas)

If you have a value to the left, or if none then cells with values on the right,
you can double click to fill-down, more information on
use of the fill handle in
http://www.mvps.org/dmcritchie/excel/fillhand.htm

Then, of course, if you know what you want and where you want it
you could do it in a macro.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Clueless" wrote ...
I am trying to generate a list of numbers, incrementally increased to my
specifications. I absolutely hate the idea of having to do these
myself....is there a way to have Excel or Access generate this list for me?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If I create a random list in Excel, does it repeat numbers? Kelly Excel Worksheet Functions 2 March 30th 05 04:05 AM
Is there a way to create a drop-down list of links in Excel? t_boden Excel Worksheet Functions 1 February 3rd 05 06:14 PM
create a drop down list with the source from a different workbook Sampath Excel Discussion (Misc queries) 2 January 8th 05 07:57 PM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
list of sequential numbers kellyaek Excel Discussion (Misc queries) 2 December 3rd 04 04:45 PM


All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"