+ Reply to Thread
Results 1 to 2 of 2

Group/Sort Data using helper column (Index Match)

  1. #1
    Registered User
    Join Date
    11-25-2016
    Location
    London
    MS-Off Ver
    Office 13
    Posts
    2

    Group/Sort Data using helper column (Index Match)

    I'm looking to find a way to group/sort data based on a 2 serial numbers, in this case called Demand Number and Supply Number.

    The logic I'm trying to apply is if an items supply number matches the demand number of another item then it should be shown underneath it for example if you were to sort the data shown below:

    chTuZ.png

    You would get the following result:
    SxKBR.png

    I think I will need to use some helper columns, to apply 'levels' to the items but I'm really not sure where to go.

    Thanks for the help!!

    Data as text:

    Please Login or Register  to view this content.
    Last edited by qwertyuiop123654; 03-30-2020 at 05:53 PM.

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,387

    Re: Group/Sort Data using helper column (Index Match)

    In the sorted list, why doesn't the Suspension come after the Car instead of the Engine? And so it seems that if there are 2 Demand numbers that match the Supply number that you just list one of them, and then look to see if another Demand number matches the new supply number? And does the nut follow the washer because there were no demand numbers that matched "10095"? This seems to be some weird sorting logic. And why does the Washer come after the Suspension and not one of the Nuts below it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extracting data based on two helper column criteria
    By QlooQ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2018, 04:28 PM
  2. Replies: 1
    Last Post: 03-29-2018, 07:58 AM
  3. Sort by helper column even if values in helper are alike
    By NoSleepForMe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2016, 04:14 AM
  4. Replies: 1
    Last Post: 04-18-2014, 05:54 PM
  5. [SOLVED] vba overwrite data if 2 condition is met ( date and if helper column does not have error)
    By vlady in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-12-2013, 11:28 PM
  6. Conditional Formatting every other group of rows WITHOUT HELPER COLUMNS
    By distribution master in forum Excel General
    Replies: 1
    Last Post: 05-14-2013, 03:46 PM
  7. Group & sort rows that have a specific value in column C
    By Lex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2006, 07:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1