View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How do I create a list of sequential numbers in Excel 2003?

Another formulas option to play with ..

Assume the 3x5 grid is in B2:D6,
and the starting number for the grid will be input in B1

Place in B2:
=IF($B$1="","",$B$1+ROW(A1)*3-3+MOD(COLUMN(A1)-1,3))
Copy B2 across to D2, fill down to D6.

Test it out by inputting a start number say, 100 into B1.
You'd get the required results in B2:D6, ie:

100 101 102
103 104 105
106 107 108
109 110 111
112 113 114

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"kateinmo" wrote:
I need to print on 3 x 5 cards columns of sequential numbers. I have set up a
print area so that the columns fit neatly on the card. It's a pain to type
the numbers in manually, but they do not exist in a database. Is there a
formula for typing in the first number in the top left cell and the ending
number in the bottom right cell, and the program automatically filling in the
columns with the correct numbers? Even if it can be done only one column at a
time, it would be a huge help.
--
kateinmo