Hello everyone. I have this table
First row contains the headers. I want a vba code that will compare all the rows and tell me which are the combinations of n numbers that appear most frequently on a row. for example the numbers 4,17,35 appear most frequently together, 4 times. I mention that periodically other rows will be added to the table. If you also know a dynamic formula, it would be even better. Mode.mult does not work. thank you all and I look forward to your ideas.
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 |
5 | 9 | 10 | 15 | 16 | 31 | 32 | 33 | 34 | |||||||||||||||||||||||||||
4 | 8 | 15 | 17 | 20 | 21 | 23 | 24 | 25 | 28 | 29 | 35 | ||||||||||||||||||||||||
1 | 7 | 9 | 12 | 19 | 22 | 26 | 28 | 31 | 36 | ||||||||||||||||||||||||||
1 | 2 | 6 | 8 | 10 | 12 | 16 | 18 | 20 | 21 | 24 | 26 | 31 | |||||||||||||||||||||||
5 | 6 | 10 | 16 | 25 | 35 | 36 |