I hope somebody can help me with this - I have cracked my head over it and cant seem to figure out a way.
I need to find out common numbers between columns. Each column has multiple number entries seperated by a comma.
Column A: "5592,12222" and Column B: "1,2,3,4,5592,123123" and Column C: "3, 4"
I need to find out any numbers that are found in more than 1 column. Hence, the result should be something like "3,4,5592". If no match is found then maybe can indicate by coloring the cell.
My data is over 50,000 rows and 30 columns. I need to do this for each row one by one.