How to add consequetive numbers in column

C

Chadi

How do I add an X amount of consequetive numbers in a particular column,
starting from say for example Column1 / Row 1, Number 1 downt to Column 1 /
Row 50, Number 50?
 
D

Dave Peterson

I'd do this:

Edit|Goto|type A1:A50|hit enter
type:
=row()
and hit ctrl-enter (which will fill all those cells with that formula)

Then (with A1:A50 still selected):
edit|copy
edit|paste special|values
 
C

Chadi

Thanks for your reply but it is not working in my case.

I am inserting IP addresses such as

147.202.11.11

How would I go about in this case? I tried

A147.202.11.11:A147.202.11.20 and got an error of course
 
B

Bryan Hessey

try

="147.202."&row()+10&"."&row()+10

="147.202." & row()+10 & "." & row()+10

or variations of that

HTH

--
Thanks for your reply but it is not working in my case.

I am inserting IP addresses such as

147.202.11.11

How would I go about in this case? I tried

A147.202.11.11:A147.202.11.20 and got an error of course
Click to expand...
 
C

Chadi

That did not work sorry

I'll be more detailed

For example:

A1 - A20

Starting with

147.202.65.100
(A1)

through

147.202.65.120
(A20)

How can this HOPEFULLY be acheived?
 
P

Peo Sjoblom

You need to copy to A21 to get from 100 to 120

in A1 put

="147.202.65."&ROWS($A$1:A100)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
B

Bryan Hessey

In A1 put

="147.202.65."&ROW()+99

and formula-copy to A21

This will give the range required.

Peo, I couldn't get yours to work, did I miss something?

Bryan

--
 
C

Chadi

I'm trying this and it is adding "100" plus 1 per row. I don't want that

Starting from 147.202.70.194 thru 147.202.70.254

After highling A37-A101

="147.202.65."&ROWS($A$1:A100)
(ctrl enter)

It shows up as
Starting from 147.202.70.194.100
 
B

Bryan Hessey

Chadi,

The easy way is to select your first cell, say A37, put

="147.202.70."&ROW()+157

to give you 147.202.70.194 (or + any number to give what you require)

then click on that cell, and put your cursor in the bottom right corner
of the cell so that it becomes a +
click and drag that (known as formula drag) downwards as far as you
need

Hope this helps

--
 
D

Dave Peterson

How does the .65. change to .70.?

I selected A37:A101, typed this:
="147.202.65."&ROW(A194)
and hit ctrl enter.

But I ended up with with:
147.202.65.258
in A101
 
B

Bryan Hessey

Hi Dave,

it would need the text portion to be manually amended the row after
..255, it seemed easier than doing a full 255.255 calculation

Bryan
 
Top