Sorting IP Addresses in Excel - Update 1 with subnet/cidr support
This video demonstrates how to create an Excel Add-In that will allow you to convert your IP addresses into their integer values, so that the IP can be "properly" sorted by all 4 octets of an IPv4 addresses (versus string comparison sorts). It includes the latest update to check for a CIDR notation and to split and convert. The link to the file on my site is with the latest changes.
Download the function text from my website:
https://www.ipdevnet.com/iptoint/ipto...