Is there a simple way to extract common numbers from two cells with comma-separated numbers?
I have cells with 12 comma separated numbers in each cell. (They are not all unique. Some numbers can be repeated twice. but never more than twice. Numbers are all positive, and one or two digit numbers only)
My data is like so: they are in column A:
The result I would like to have is like so:
I need a solution without separating values into different columns, please. Thanks for your help.
Since there can be numbers repeating twice in some cases, I am also open to a solution like this, too.
I have cells with 12 comma separated numbers in each cell. (They are not all unique. Some numbers can be repeated twice. but never more than twice. Numbers are all positive, and one or two digit numbers only)
My data is like so: they are in column A:
Rich (BB code):
11,11,13,15,16,18,20,20,26,27,28,29
8,9,10,12,13,14,18,20,21,22,24,28
13,13,14,14,15,17,18,19,20,21,23,25
6,6,8,10,12,14,15,17,18,20,20,25
11,13,17,18,19,19,22,25,26,28,28,31
7,9,15,16,17,18,23,24,24,25,26,27
7,9,11,12,12,15,16,16,18,18,20,23
9,11,13,15,18,22,23,24,25,28,29,29
7,9,10,11,12,12,13,14,15,16,19,22
5,10,11,12,12,16,17,18,20,22,24,25
7,10,13,16,16,17,18,19,21,23,24,24
10,14,16,18,18,19,21,23,23,25,27,28
The result I would like to have is like so:
I need a solution without separating values into different columns, please. Thanks for your help.
Since there can be numbers repeating twice in some cases, I am also open to a solution like this, too.