+ Reply to Thread
Results 1 to 3 of 3

Find the most common combination of 3

  1. #1
    Registered User
    Join Date
    10-06-2015
    Location
    England
    MS-Off Ver
    2013
    Posts
    3

    Find the most common combination of 3

    I have a worksheet containing 1000 rows of data. Each row has 6 columns, each cell contains a value of 1 - 100. For example:

    6 30 47 63 88 100
    17 33 63 88 98 100
    25 26 44 89 90 96
    63 77 88 89 99 100


    The most common combination of the 3 numbers in this table is 63, 88, 100 because it occurs in rows 1, 2 and 4. For this example, I'm not treating different orders as different combinations. In other words, if the order in the table showed 100, 63, 88 I would still class that as the same combination of 3 numbers, not a separate combination.

    My data range is in Sheet 1, A1:F1000.

    In Sheet 2, how can i get excel to show me the top 3 most common combinations of 3, and the number of times they each occur? I was hoping to use a VBA solution rather than pivot tables or formulas.
    Last edited by SAE.01; 10-30-2015 at 11:24 AM.

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Find the most common combination of 3

    Maybe :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-31-2020
    Location
    Budapest
    MS-Off Ver
    2016
    Posts
    1

    Re: Find the most common combination of 3

    Is it possible to change this code so that it shows the most common combination of 2?

+ 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. How to find out last 5 digits which are common
    By nagesh.tvsr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2014, 04:03 AM
  2. Identify Common Words (and combination of)
    By ItsMeH in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 05:53 PM
  3. How to find the most common numbers?
    By alikirca20 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-04-2013, 09:34 AM
  4. Most common combination - is this possible
    By LIJ in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-12-2012, 03:11 PM
  5. Find out what these numbers have in common
    By morsoe in forum Excel General
    Replies: 3
    Last Post: 07-27-2011, 07:39 AM
  6. find best combination
    By orenw8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2010, 07:39 PM
  7. trying to find second most common number
    By kyle2636 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2009, 03:04 AM

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