Hi,
I have a spreadsheet that looks like this:
A1
234
456
925
432
546
123
Is there anyway to find out how many times a combination of numbers occurs regardless of the order? So in the example the combination of numbers 2,3,4 occurs two times (234 & 432). I can separate the numbers into 3 columns if that helps in any way. Any suggestions would be greatly appreciated.
Thanks
Bookmarks