Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hexadecimal Sorting (2003/11.8134.8132 SP2)

    Hello honored Excel Geeks,
    I have a spreadsheet which contains a column of 7-digit HEXADECIMAL serial numbers (for example, 690287e). How can I sort my spreadsheet by this column? I tried to create a custom list (123 ...def) to sort by, but the custom list dialog discards numbers. Can this be done without programming? I thank any of you in advance who respond ...
    CalDeCal

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Hexadecimal Sorting (2003/11.8134.8132 SP2)

    If you have the Analysis Toolpak add-in installed, you can use the HEX2DEC function in a new column, and sort on that?
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: Hexadecimal Sorting (2003/11.8134.8132 SP2)

    Welcome to Woody's Lounge!

    If you haven't already done so, install the Analysis ToolPak add-in:
    - Select Tools | Add-Ins...
    - Tick the check box for Analysis ToolPak.
    - Click OK.

    Say that your serial numbers are in A1 and down.
    Enter the following formula in B1:

    =HEX2DEC(A1)

    Fill down as far as needed.
    Now sort the range including columns A and B plus other columns you need on column B.

  4. #4
    New Lounger
    Join Date
    May 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hexadecimal Sorting (2003/11.8134.8132 SP2)

    Thanks, Hans and Rory! I installed the Analysis ToolPak Addin ... which, before your helpful and speedy replies, I was unaware of. This is a big help ... thanks!

Posting Permissions

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