Hello everyone!
I have thousands of lines, with six columns
I want to find them a trio of numbers, from left to right, appears the most
Sample data :
30 1 2 4 5 8
31 5 7 9 21 22
32 3 5 7 22 23
33 6 8 1 23 24
34 3 5 9 24 25
35 6 8 15 25 26
36 4 5 8 26 27
37 8 10 12 27 28
5 7 9 9 28 29
39 3 5 14 29 30
40 1 4 5 8 31
Most combination is :4,5,8 =Appears in three rows
And then :5,7,9 =Appears in two rows
Non-Volatile functions !
The solution can be in 3-cell, or in one cell.
Thank you !
Bookmarks