I need to find the most frequent triplets, quadruplets in a given row in Excel. There are a hundred rows and each has 8 numbers. For example, 20 out of 100 rows have these numbers 3, 5, 7, 86. Thereby, these are the most frequent quadruplets in the spreadsheet. Another example, 25 out of 100 rows contain these numbers 3, 5, 7. Thereby, these are the most frequent triplets in the spreadsheet. Note, for example, 24 out of 100 rows contain 3, 5, 8 numbers in every 24 rows but the number of frequency is less than in the previous example (25). So, we don't consider this as the most frequent triplets pattern.
A simple example with triplets :
3, 5, 7, 10
3, 5, 1, 8
7, 3, 6, 5
5, 7, 3, 10
Result:
(3, 5, 7 ) = 3 times
(3, 5, 8 ) = 1 times
Final result:
Triplet pattern - 3, 5, 7 as it appeared 3 times
I need the same thing for most common quadruplets pairs in a row
P.s. I have just a basic knowledge of Excel. Thanks.
Bookmarks