+ Reply to Thread
Results 1 to 4 of 4

Finding Most Frequently Occurring Combinations

  1. #1
    Registered User
    Join Date
    03-18-2015
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Windows 7
    Posts
    2

    Finding Most Frequently Occurring Combinations

    I have two columns (ID and Part Number) and am looking to identify all possible "Part" combinations that we ship out.

    ID = Individual Sales Orders
    Part Number = Individual Part Numbers within each Sales Order

    Would like to see:
    Part 1234 and 5678 = Count of 80
    Part 5678 and 3333 = Count of 90
    Part 1234 = Count of 110


    Shipping Parts 2014-2015.xlsx

    Any help on how I can put a formula together to calculate this would be great.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Finding Most Frequently Occurring Combinations

    There are 328 distinct part numbers, which means there north of 50,000 2-element combinations. I don't think it would be practical to use formulas.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-18-2015
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Windows 7
    Posts
    2

    Re: Finding Most Frequently Occurring Combinations

    Thanks shg for your reply. If not a formula, any other suggestions on how one would find a solution?

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Finding Most Frequently Occurring Combinations

    The alternative is a macro (VBA). Some kind soul may be willing.

+ 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. Replies: 13
    Last Post: 09-29-2015, 11:22 AM
  2. Replies: 7
    Last Post: 01-14-2015, 11:38 PM
  3. Return most frequently occurring text in row
    By penfold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2011, 12:38 PM
  4. Most frequently occurring text
    By Deanomcbeano in forum Excel General
    Replies: 4
    Last Post: 08-12-2009, 08:58 AM
  5. most frequently occurring value
    By Pivotrend in forum Excel General
    Replies: 3
    Last Post: 12-23-2005, 08:10 AM

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