View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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