![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Right and Len formulas together | PDGood | Excel | 4 | 11-20-2015 06:50 AM |
formulas | MSA5455 | Excel | 3 | 12-19-2014 01:50 AM |
Help with IF or ELSE Formulas | tsaladyga | Excel | 4 | 07-23-2014 09:04 AM |
![]() |
mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |
Opening .pst with dummy values | ran_sushmi | Outlook | 0 | 08-19-2009 01:56 AM |