Hey Excel Pros,

Im having issues with my excel spreadsheet. I cant seem to find how to do what Im looking for.
Normally if i type "1" in A1, "2" in B1, and "3" in C1, grab all 3 boxes and then drag the corner, itll increment the numbers all the way down the column. Im trying to do that same thing with IP addresses but cant figure out how.



Im wanting to do a mixture of /22 /23 /24 and /25s.

What formula do i need to insert into A1 in order to do the following?

10.0.0.0/22 in A1
10.0.4.0/22 in B1
10.0.8.0/22 in C1
And when the corner dragged, it continues on in that fashion?

Also, the same for /25s, since thats going to affect the 3rd and 4th octets.

10.0.0.0/25 in A1
10.0.0.128/25 in B1
10.0.1.0/25 in C1
etc when dragged

Thanks in advance for the help and I look forward to hearing form you.

Hi and welcome
And what should happen when 10.0.252.0 is reached? Sitch to 10.1.0.0 and so on?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi PecoFlyer,

I dont plan on getting high enough to alter the 2nd octet. Itll only be about 30 lines.

Thanks