Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort IP address list (XP/2002)

    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?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 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).
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •