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.
Bookmarks