How to make all combinations of 6 numbers from 49 numbers and compare their?

[stanley]

Hello

i wolud like make all of combinations of 6 numbers from 49 numbers and compare their with list of my combination of 6 numbers and i wanna know if some of my combination is duplicate. Can you help me? Nubmer all of cobminations is 13.983.816

[JBeaucaire]

If you make a list of ALL 13mil combinations, then you won't need to compare it to your short list, it would be in there, after all, it would be a list of ALL combinations, yes?

Lottery comparison sheets are listed all over the place, there's no real need to redo this, it's been done a million times.

Recommendation, you don't compare your "combination" against all other combinations (13mil possiblities), you compare your 6 individual choices to the the winning choices.

Attached is one I did long ago, same basic idea, compare everyone's numbers with the winning numbers and light up the matches with conditional formatting. Keep pressing F9 to see how it works with different numbers each time.