I have this table in Excel:
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