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