software

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:
gt;
gt; How do I add an X amount of consequetive numbers in a particular column,
gt; starting from say for example Column1 / Row 1, Number 1 downt to Column 1 /
gt; Row 50, Number 50?
gt;
gt; --
gt; 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.comquot;Dave Petersonquot; wrote:

gt; I'd do this:
gt;
gt; Edit|Goto|type A1:A50|hit enter
gt; type:
gt; =row()
gt; and hit ctrl-enter (which will fill all those cells with that formula)
gt;
gt; Then (with A1:A50 still selected):
gt; edit|copy
gt; edit|paste special|values
gt;
gt;
gt;
gt; Chadi wrote:
gt; gt;
gt; gt; How do I add an X amount of consequetive numbers in a particular column,
gt; gt; starting from say for example Column1 / Row 1, Number 1 downt to Column 1 /
gt; gt; Row 50, Number 50?
gt; gt;
gt; gt; --
gt; gt; www.talkjesus.com
gt;
gt; --
gt;
gt; Dave Peterson
gt;


try

=quot;147.202.quot;amp;row() 10amp;quot;.quot;amp;row() 10

=quot;147.202.quot; amp; row() 10 amp; quot;.quot; amp; row() 10

or variations of that

HTH

--

Chadi Wrote:
gt; Thanks for your reply but it is not working in my case.
gt;
gt; I am inserting IP addresses such as
gt;
gt; 147.202.11.11
gt;
gt; How would I go about in this case? I tried
gt;
gt; A147.202.11.11:A147.202.11.20 and got an error of course
gt; --
gt; www.talkjesus.com
gt;
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; I'd do this:
gt; gt;
gt; gt; Edit|Goto|type A1:A50|hit enter
gt; gt; type:
gt; gt; =row()
gt; gt; and hit ctrl-enter (which will fill all those cells with that
gt; formula)
gt; gt;
gt; gt; Then (with A1:A50 still selected):
gt; gt; edit|copy
gt; gt; edit|paste special|values
gt; gt;
gt; gt;
gt; gt;
gt; gt; Chadi wrote:
gt; gt; gt;
gt; gt; gt; How do I add an X amount of consequetive numbers in a particular
gt; column,
gt; gt; gt; starting from say for example Column1 / Row 1, Number 1 downt to
gt; Column 1 /
gt; gt; gt; Row 50, Number 50?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; www.talkjesus.com
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533600That 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

=quot;147.202.65.quot;amp;ROWS($A$1:A100)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Chadiquot; )gt; wrote in message
...
gt; That did not work sorry
gt;
gt; I'll be more detailed
gt;
gt; For example:
gt;
gt; A1 - A20
gt;
gt; Starting with
gt;
gt; 147.202.65.100
gt; (A1)
gt;
gt; through
gt;
gt; 147.202.65.120
gt; (A20)
gt;
gt; How can this HOPEFULLY be acheived?

In A1 put

=quot;147.202.65.quot;amp;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:
gt; That did not work sorry
gt;
gt; I'll be more detailed
gt;
gt; For example:
gt;
gt; A1 - A20
gt;
gt; Starting with
gt;
gt; 147.202.65.100
gt; (A1)
gt;
gt; through
gt;
gt; 147.202.65.120
gt; (A20)
gt;
gt; How can this HOPEFULLY be acheived?--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533600I'm trying this and it is adding quot;100quot; plus 1 per row. I don't want that

Starting from 147.202.70.194 thru 147.202.70.254

After highling A37-A101

=quot;147.202.65.quot;amp;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

=quot;147.202.70.quot;amp;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:
gt; I'm trying this and it is adding quot;100quot; plus 1 per row. I don't want
gt; that
gt;
gt; Starting from 147.202.70.194 thru 147.202.70.254
gt;
gt; After highling A37-A101
gt;
gt; =quot;147.202.65.quot;amp;ROWS($A$1:A100)
gt; (ctrl enter)
gt;
gt; It shows up as
gt; Starting from 147.202.70.194.100--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533600How does the .65. change to .70.?

I selected A37:A101, typed this:
=quot;147.202.65.quot;amp;ROW(A194)
and hit ctrl enter.

But I ended up with with:
147.202.65.258
in A101
Chadi wrote:
gt;
gt; I'm trying this and it is adding quot;100quot; plus 1 per row. I don't want that
gt;
gt; Starting from 147.202.70.194 thru 147.202.70.254
gt;
gt; After highling A37-A101
gt;
gt; =quot;147.202.65.quot;amp;ROWS($A$1:A100)
gt; (ctrl enter)
gt;
gt; It shows up as
gt; Starting from 147.202.70.194.100

--

Dave Peterson