IN Cell C14 I have an IP 10.7.182.1
I need that value +1 in the 3rd octet of c18
so my output would be 10.7.183.1
I also have an IP address that needs to be in cell6b that needs the first 3 octets copied but with a different value for the 4th octet in another cell.
Please help, if possible.
Last edited by kmdiaopm; 04-17-2014 at 11:00 AM.
Welcome to the forum!
Because we want all the threads to be highly searchable so people can find existing solutions, it's important to us that the title of the thread reflect what's being requested. It is, in fact, Rule Number One.
So yours should be something like, "changing the numbers in IP octs in one cell."
Once you've done that, we'll be happy to help you.
Thank you so much, I have changed it.
Used SEARCH to find the full stop positions; and then VALUE/LEFT/RIGHT to turn those into the numbers for each Octet in helper cells; and then recomposed.
Once you've got them as numbers in helper cells, you can do whatever kind of math on them you want.
See attached.
that fails though if the octet ends in 255 as 10.7.255.1 needs to be 10.8.0.1
try this converts ip to decimal adds 256 then converts back
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Martin. I just used this to resolve something I had been looking at for a while now. This is great. Thanks for posting.
I'm not a network expert. I have checked the IP address rules, it seems too complex. I'm not sure whether it is possible to generate a list of valid IP addresses through a single Excel formula.
https://www.2000trainers.com/cisco-c...ressing-rules/
Host ID cannot be all binary 1s
Host ID cannot be all binary 0s
Network ID cannot be all binary 0s
Network ID cannot be all binary 1s
Network ID cannot be decimal 127
IP address cannot be all binary 0s
IP address cannot be all binary 1s
Network IDs of 224 and above in the first octet cannot be assigned to hosts
Row row row your boat
Gently down the stream
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks