tl/dr: Here is a nice chart for you! I created the below chart a few years ago to post up for reference some of my coworkers would forget what our subnet mask was suppose to be. It didn't really work ...
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 ...