How to add consequetive numbers in column
 

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?


--
www.talkjesus.com

How to add consequetive numbers in column
 

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



Chadi wrote:

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?

--
www.talkjesus.com

--

Dave Peterson

How to add consequetive numbers in column
 

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
--
www.talkjesus.com


"Dave Peterson" wrote:

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



Chadi wrote:

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?

--
www.talkjesus.com

--

Dave Peterson

How to add consequetive numbers in column
 

try

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

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

or variations of that

HTH

--

Chadi Wrote:
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
--
www.talkjesus.com


"Dave Peterson" wrote:

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



Chadi wrote:

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?

--
www.talkjesus.com

--

Dave Peterson



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533600

How to add consequetive numbers in column
 

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?

How to add consequetive numbers in column
 

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


"Chadi" ) wrote in message
...
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?

How to add consequetive numbers in column
 

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

--

Chadi Wrote:
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?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533600

How to add consequetive numbers in column
 

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

How to add consequetive numbers in column
 

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

--

Chadi Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533600

How to add consequetive numbers in column
 

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



Chadi wrote:

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

--

Dave Peterson

How to add consequetive numbers in column
 

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

Dave Peterson Wrote:
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



Chadi wrote:

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

--

Dave Peterson


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533600

How to add consequetive numbers in column
 

I just figured the the OP used the wrong range--maybe A37:A95 instead???

Bryan Hessey wrote:

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

Dave Peterson Wrote:
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



Chadi wrote:

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

--

Dave Peterson

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533600

--

Dave Peterson