creating a table with numbers divisible by 12

J

Jeanne

Is there a formula to create a table that has numbers that are divisible by
12. I created one by having a sequencial number in one column and then a
formula in the next column
=sum(b1*12) and in b1 is 1. In next row =sum(b2*12) and in b2 is a 2.. etc.
Is there an easier way to do this. I need to create a table that goes out to
about $300,000
 
M

Myrna Larson

Put 12 in B1. Put 24 in B2. Select B1 and B2, then drag the fill handle (the
little black square at the lower right corner of B2) down.
 
M

Myrna Larson

Another way. Put the number 12 in a cell. Select that cell. Then Edit/Fill
Series, and set the step value as 12.
 
D

duane

that's like 30,000 rows or so....

a macro can do this dog work

sub macro()
for i=1 to 50000
max = 300000
' change 300000 to whatever you want
'change cell location to wherever you want
cells(i,1) = 12*i
if cells(i,1) >max then goto alldone
next i
alldone:
end su
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sums divisible by 12 2
Insert Index into a Table 1
how do i create a divisible formula 3
Setting column width in a table with a macro is not working 0
Working outlook via vba code with xlsx - error 0
Cumulative formula for word table 0
Rolling 12 month 9
Conditional Formating to Show Numbers NOT Divisible by another 3

Top