+ Reply to Thread
Results 1 to 4 of 4

Find number of possible combinations in a list

  1. #1
    Registered User
    Join Date
    09-14-2020
    Location
    Brazil
    MS-Off Ver
    365
    Posts
    6

    Find number of possible combinations in a list

    Good night people!

    I would like some help to develop some technique to find how many combinations I have within an existing list.

    Example:

    ORDER A - ITEM 1
    ORDER A - ITEM 4
    ORDER A - ITEM 8
    ORDER B - ITEM 4
    ORDER B - ITEM 1
    ORDER C - ITEM 4
    ORDER C - ITEM 8
    ORDER C - ITEM 5
    ORDER C - ITEM 3
    ORDER D - ITEM 8
    ORDER D - ITEM 4

    My problem is trying to find out for example how many orders I have with items 4 and 8 in the same order and so on. An analysis of the mix of items on each order, I have tried everything here but I have not yet succeeded ... The problem too and that there would not always be the sequence of the same items ... In my head it would practically look like:

    ITEM 4 AND ITEM 8 - 3 ORDERS
    ITEM 1 AND ITEM 4 - 2 ORDERS
    ITEM 4, ITEM 8 AND ITEM 1 - 1 ORDER

    Forgive my English, I still haven't found a solution in BR.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Find number of possible combinations in a list

    "ORDER A - ITEM 1" is in single or multi column?
    Could you attach a sample workbook?

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Quang PT

  3. #3
    Registered User
    Join Date
    09-14-2020
    Location
    Brazil
    MS-Off Ver
    365
    Posts
    6

    Re: Find number of possible combinations in a list

    Ok, I'm attaching my base with current and a tab with what would probably be the end result.

    Adding that I would need to find subcombination within a combination as well.

    Obs. I have an average of 18000 different items ...
    Attached Files Attached Files

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Find number of possible combinations in a list

    It probably too complicated for formula solution.
    I suggest VBA, but I am not familiar with it.
    Hope someone jump in with VBA solution.

+ 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. [SOLVED] To find all combinations of numbers from list of numbers that adds upto a specified number
    By Vivek2705 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-07-2019, 06:33 AM
  2. Find most common numbers and number combinations
    By Raymundo46 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-17-2018, 04:25 PM
  3. [SOLVED] Geting highest number value from list with values which are text/number combinations
    By igormigor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2016, 10:48 AM
  4. Replies: 1
    Last Post: 06-04-2014, 05:40 PM
  5. find all combinations of cells that add up to certain number
    By AD in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-18-2005, 09:35 AM
  6. [SOLVED] find all combinations of cells that add up to certain number
    By AD in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-17-2005, 03:55 PM
  7. [SOLVED] find all combinations of cells that add up to certain number
    By AD in forum Excel General
    Replies: 1
    Last Post: 11-17-2005, 03:40 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