I have a sheet with 3k+ lines and 15 columns. Each column is filled with a random number from 1 to 25. Very much like lottery results, where each column is a number drawn from the lottery. (from 1-25)
I need to compare whether the sequence on line 1 (for all 3k+ lines) is found in any other line.
Meaning, whether the lottery results appeared twice. The catch is ball 1 can appear in any of the different 15 columns.
Is the an excel formula I can place in the following column? Or a VBA (ideally) code to compare?