Hello,
I have rows of numbers inputted horizontally. I want to find the combinations in these 5 columns that have similar numbers that appear in the same row.
For example:
3,6,7,2,5
4,8,9,1,2
6,5,1,0,8
2,7,0,1,9
I want the result to show that often 6 and 5, 2 and 7, 1 and 0, 9 and 2, and 1 and 8 appear together regardless of which column it is in.
Also, it would be great to know if the same combinations of all 5 numbers in the row have reappeared before.
Many thanks,
Cheers!
Bookmarks