Hi all,
I've been trying to figure this out for a while and can't find anything online to help so thought I'd post it here.
I have a list of numbers with three columns.
Each column has a number in it.
What I need to find is what combination of numbers occurs the most across the whole row.
The kicker is that I don't care about the order of the numbers, for instance:
1 2 3
3 2 1
2 1 3
Etc..
Are all the same, as far as this goes, and should be identified as a duplicate "pattern
In that example.. rows 1, 3 and 5 match the criteria.. so my most frequently repeating pattern consists of the numbers 1, 2 and 3.
I hope this makes sense and thanks for any assistance!
Bookmarks