# Posts by tachyon

• ## Find Common Numbers Between 2 Columns

Re: Find Common Numbers Between 2 Columns

hey thanks for ur reply ...[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]Guess my message din go thru

I need to go row by row thru each column and find out numbers which occur more than once in the row. Each column has multiple numbers seperated by a comma ... for example "5592,12222,2,3,4,5592,123123"

I need to list out which ever numbers occur in more than 1 column for the same row.

• ## Find Common Numbers Between 2 Columns

Hi all,

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.

For example:
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.