Hi
I found this earlier post about finding the most common combinations of 3 in a worksheet:
https://www.mrexcel.com/forum/excel-questions/898307-find-most-common-combination-3-a.html
I have a similar problem, but instead of 6 coloums and combinations of 3, I have 20 coloums and want to find combinations of 10.
I've tried to change both the macros given in the other post, but my knowledge of macros are very basic so it gets wrong every time I try.
Can anyone help me rewrite either of the macros so it will work for my situation?
I found this earlier post about finding the most common combinations of 3 in a worksheet:
https://www.mrexcel.com/forum/excel-questions/898307-find-most-common-combination-3-a.html
I have a similar problem, but instead of 6 coloums and combinations of 3, I have 20 coloums and want to find combinations of 10.
I've tried to change both the macros given in the other post, but my knowledge of macros are very basic so it gets wrong every time I try.
Can anyone help me rewrite either of the macros so it will work for my situation?