Results 1 to 4 of 4

Thread: sorting HELP!!

  1. #1

    sorting HELP!!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Column A has parent part numbers. Column B has varying quantities of component parts of the parent. How can I sort based on the numerical value of the parent part while still keeping the indented components list attached? Thanks for any help!

    i.e.

    40-1000-00
    ............... ..10-1000-00
    ..................20-1000-00
    ..................30-1000-00
    41-1000-00
    ..................10-1000-00
    ..................20-1000-00
    ..................30-1000-00
    ..................32-1000-00
    39-1000-00
    ..................10-1000-00
    ..................20-1000-00

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Assuming your data begins in row 2, then in C2 add a helper column with formula:

    =IF(A2<>"",A2,C1)

    copied down.

    Then Copy this column and Paste Special >> Values over itself.

    Then perform a Sort with sort level set as by Column 3 first, then by Column 1 second, and by column 2 last.

    You can then delete the helper column.


  3. #3
    Thanks NBVC! I had 15,000+ lines of part numbers and components that just became one less headache. If you're ever in L.A. I owe you a beverage of choice!

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    You're welcome


Posting Permissions

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