![Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc](https://chentiangemalc.files.wordpress.com/2011/02/image10.png)
Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc
![Simple visual tool to help you understand more about IPv4 Subnets, in Excel Spreadsheet" on Show IP Protocols Simple visual tool to help you understand more about IPv4 Subnets, in Excel Spreadsheet" on Show IP Protocols](https://lh4.ggpht.com/-n2HQTlPauzQ/T6dJVsK-EUI/AAAAAAABGF4/sQhWPsLi5Ls/ipv4-32-prefix-lengths_thumb%25255B3%25255D.png?imgmax=800)
Simple visual tool to help you understand more about IPv4 Subnets, in Excel Spreadsheet" on Show IP Protocols
![Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc](https://chentiangemalc.files.wordpress.com/2011/02/image15.png)
Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc
![Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc](https://chentiangemalc.files.wordpress.com/2011/02/image_thumb1.png?w=380&h=310)
Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc
![Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc](https://chentiangemalc.files.wordpress.com/2011/02/image2.png)
Geeky Excel Formulas – Subnet Math / Group By Subnet using Built-In Excel 2010 Formulas | chentiangemalc
![Making an excel file to calculate network mask and wildcard mask. I'm wanting the best way to get excel to list a 1 or 0 for the base 10 IP address typed Making an excel file to calculate network mask and wildcard mask. I'm wanting the best way to get excel to list a 1 or 0 for the base 10 IP address typed](http://i.imgur.com/GWXTEcS.jpg)