Comparing Numbers in rows

[mrv1976]

Hi,

Let me explain what I'm trying to do and was wondering if it's possible to accomplish in Excel. I like to play Keno and they will list all the previous games online and show you which numbers came out. So I created an Excel spreadsheet copied and pasted the numbers into each row and column. I also created a macro which sorts each row from left to right (smallest to largest). So my question is there a way to compare all rows and find out which numbers appeared together so I can see possibly see a pattern of what numbers are showing up together in each game to help me decide which numbers to choose. Let me know if that makes sense.

[taps]

Hi mrv1976,

Could you show us the macro file?