Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort within a number (Excel 2003)

    I've been asked by a colleague how to sort data that is a number but they want to sort by the eighth and ninth number in a 10-digit number. Is there some way to do this? See attached word doc with sample numbers. Thanks....Carol
    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 within a number (Excel 2003)

    It would have made more sense to attach an Excel workbook.

    Are the values in the Excel workbook numeric values that have been formatted to display leading zeros, or are they text values?

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

    Re: Sort within a number (Excel 2003)

    Here's a sample workbook that demonstrates a possible approach, using an extra column to extract the 8th and 9th digits.
    Attached Files Attached Files

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort within a number (Excel 2003)

    I didn't get the spreadsheet but they are text.

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

    Re: Sort within a number (Excel 2003)

    Your colleague should be able to use the formulas from column B or C in the example I posted in my previous reply. If the data are sorted on this column, the column with the ten-digit numbers will be sorted with it.

  6. #6
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort within a number (Excel 2003)

    Thank you....that works.

Posting Permissions

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