I have this table in Excel:
Column1 Column2 Column3 Column4 Column5 Column6
50 24 8 4 3 1
50 18 8 7 1 1
49 8 7 5 3 1
49 15 4 3 1 1
48 15 10 8 4 3
44 20 5 3 1 1
43 4 3 3 3 1
42 16 5 5 1 1
41 14 10 6 3 3
41 13 11 8 6 5
40 9 5 3 2 1
39 9 7 4 4 3
39 8 7 6 4 1
39 9 6 4 3 3
38 8 7 5 3 2
38 14 8 4 4 3
38 17 15 10 8 8
37 10 10 6 2 2
37 19 8 4 3 1
37 23 23 3 2 2
MANY NUMBERS (AT LEAST 1000 ROWS IN THIS TABLE)
The numbers may repeat in one or more columns.
It may be something like:
1 1 1 1 1 1
OR any combo:
e.g.:
23 5 3 1 1 1
As you maybe note already, numbers are sorted from higher to lower.
number in Column1 >= number in Column2 >= number in Column3 >= number in Column4 >= number in Column5 >= number in Column6.
I want a way to find out how many times each combo of six numbers are repeating in this table.
e.g.
23 5 3 1 1 1 appears 17 times
1 1 1 1 1 1 appears 38 times and so on.
Any help with this, please ?
Thank you so much !
Bookmarks