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

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

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

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

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?

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?

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

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

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 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

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

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