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?
Results 1 to 2 of 2
Thread: Sort IP address list (XP/2002)
-
Star Lounger
- Join Date
- Apr 2002
- Location
- Pleasant Hill, CA
- Posts
- 66
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2007-05-22 17:04Sort IP address list (XP/2002)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2007-05-22 17:20Re: Sort IP address list (XP/2002)
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).
