Thread
:
How Do I sort an IP address by the 3rd Octet?
View Single Post
#
5
Bernd
Posts: n/a
Get my macro ch2str (sort_chapter.xls) from
http://www.bplumhoff.de/html/software.html
Create a helper column with =RIGHT(A1,10) and sort by this
column.
Your result will be sorted by 3. octet first then 4. octet.
Regards,
Bernd
Reply With Quote