Hello everyone! To the question...
I have 3474 tables of IP Addresses and Subnets, and I need a calculation to tell whether it's a valid IP for that subnet.
To put it simply, I need an advanced subnet calculator formula for an Excel table. :bouncing:
I'd need it to report to another field whether the two are valid or not.
Thanks in advance.
Here is the data:
I need to compare the IP in Field 3 to the subnet mask in Field 4, for Excel to decide if Field 5 says Valid or Invalid.
Edited by Nate: Your tables did't work; removed. Use Colo's HTML maker and read the FAQ, if you're interested on posting spreadsheets here.