#1
|
|||
|
|||
IP formulas for this dummy
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. |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Hi PecoFlyer,
I dont plan on getting high enough to alter the 2nd octet. Itll only be about 30 lines. Thanks |
|
Similar Threads | ||||
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 |
IF Formulas | mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |
Opening .pst with dummy values | ran_sushmi | Outlook | 0 | 08-19-2009 01:56 AM |