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 ...

You don't need a router. If you set the subnet mask on all of the PCs to be 255.255.0.0, then they should all be able to ping each other. Basically, opening up the subnet mask puts all of the PCs on ...

Subnet Mask divides the IP address into two segments and informs the computer which part is the network bit and which one is the host bit. For example, if there is an IP address: 192.168.0.1, it will ...