Home > other >  Help: how can Excel, according to the starting IP address calculation figures mask, mask, the number
Help: how can Excel, according to the starting IP address calculation figures mask, mask, the number

Time:03-31

now know that the beginning of the segment end IP address and IP address,
How to use formula to calculate the figures mask in Excel, mask, the IP number?
Need to consider to 16-bit mask,


Such as the start address for 14.0.0.0, end address for 14.0.7.255

Must be in Excel, convenient quick drag
Thanks a lot!!!!!!!!!!