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
|