subnet

Right now I've got a large list of IP addresses due to using /24 subnet breakdowns, however I want to reduce my subnets to the tightest possible subnet to accommodate IPs in the range. To this I need to know the difference between the minimum and maximum of the values within the /24 range. My...

Good Day, I am having a bit of trouble finding a solution to this one and I think that my main problem is that I don't know exactly what to search for. I’m sure that this question has been answered previously but I can’t see to find it after searching. My issue is this: I have a...

Dear All, I was look for a formula if a cell text is matching partially then vlookup from another sheet for matching value. Cell A 10.253.19.7 in Cell B & C, the formula should have if Cell A 10.253.19.* then vlookup the value from sheet2 and display Subnet mask & gateway respectively...

Hi everyone, I was hoping someone may be able to assist me with an unusual request that I have not been able to find a formula for that I have been able to modify successfully. I have a worksheet that contains the many instances of the word "Subnet" within column "D". For each instance of...

Hi guys - I have am trying to take a list of 250k IP Addresses and determine if they are in subnets that are part of my organization. I would prefer to do this with just formulas but am open to VBA as well...i just dont understand it as well. The first two columns I have, the third is my...

Hello first time poster here, I'll try to be as clear as I can :) I am currently being slowly driven to the brink of madness trying to work out why a vlookup is always returning #NA. The goal is for every IP address listed in a table I need to automatically work out the location based on the...