ExcelBanter - View Single Post - How Do I sort an IP address by the 3rd Octet?

For example I have:
172.21.34.82
172.21.48.80
172.21.48.83
172.22.42.100
172.22.42.101
172.24.10.15
172.24.10.16
172.24.102.12
172.24.14.15

And I want to sort this list by the third group of numbers.

"JF" wrote:

Trying to sort a list of IP addresses by the 3rd octet? Any Suggestions?

Thanks,
Jim