Sort IP address list (XP/2002)

Topic

New Reply

I need to sort a list of IP addresses. The standard syntax for such an address would put 63.167.121.2 before 63.167.121.19, but Excel wants to reverse them. Any suggestions?

Reply | Quote

Replies

See the attached version. You can sort on either the ‘Normalized IP’ column or on the ‘Numeric value’ column, and the IP addresses in column A will be sorted with them, in the correct value.
You can hide the intermediate columns, or you could create a single monster formula in the ‘Normalized IP’ column that incorporates the intermediate formulas (but it would be hard to maintain).

Reply | Quote