I have an Excel spreadsheet containing IP addresses and subnet masks. I need to derive the subnet of each IP address in the spreadsheet.<BR><BR>Example: IP (column A): 10.1.230.84, Subnet Mask (column ...

I've mostly used combination modem/routers in the past so I hadn't really come up against this till now. I have an ADSL modem which serves DHCP, but only to one device. It also doesn't have a ...