Matching a number sequence within a group of numbers in a cell

[artofescapingthoughts]

I have two columns of groups of numbers separated by a comma (but this delimiter can be changed) and I need to compare one column/cell against the other to identify changes.

Column C in the image (or first column in table) below is the original listing of these numbers and column D/second is the new updated list which may have new number sequences added or some removed. Is it possible to search and compare against the adjacent column (ie A1 to B1, A2 to B2) and return the missing number to a new cell? The original data in some cases will have more groups of number and in some cases have less (and the same for the Updated Data values) so will need to be compared in either direction (ie A1 to B1 then B1 to A1)

I have about 300 lines of data to compare and some of these cells have over 100 groups of numbers.

ie For the fourth row, value 2/44554 is unique to the Orignal Data column (missing from Updated Data) and I need a way to identify this value.

Original Data	Updated Data
1/1282091	1/1282091
127/756396, 50/756444, 1/1037940, 51/756444	127/756396, 50/756444, 1/1037940, 51/756444
9/113903, 3/1282091, 8/113903, 15/756400, 4/1282091, 6/1282091, 61/756396, 14/756400, 44/756396, 3/1274586, 43/756396, 6/594041, 6/113903, 48/756396, 62/756396, 42/756396, 45/756396, 47/756396, 5/1282091, 7/594041, 46/756396, 60/756396, 2/44554	14/756400, 42/756396, 62/756396, 3/1282091, 8/113903, 61/756396, 60/756396, 44/756396, 6/594041, 4/1282091, 15/756400, 43/756396, 47/756396, 6/1282091, 48/756396, 6/113903, 3/1274586, 46/756396, 9/113903, 45/756396, 5/1282091, 7/594041
111/756396, 108/756396, 96/756396, 97/756396, 110/756396, 109/756396	111/756396, 108/756396, 96/756396, 97/756396, 110/756396, 109/756396
8/532988, 2/532988, 6/532988, 9/532988, 3/532988, 1/532988, 4/532988, 5/532988, 7/532988	8/532988, 2/532988, 6/532988, 9/532988, 3/532988, 1/532988, 4/532988, 5/532988, 7/532988

Is this an impossible dream? Hoping not to have to resort to text to columns and sorting.

Thanks so much!

 

[FormR]

Hi, welcome to the forum! Something like this maybe? If not, try to post sample data that is a bit more varied and include a column(s) with the expected results.

Book1
	A	B	C	D
1	Original Data	Updated Data	Missing from Updated	New to Updated
2	1/1282091	1/1282091
3	127/756396, 50/756444, 1/1037940, 51/756444	127/756396, 50/756444, 1/1037940, 51/756444
4	9/113903, 3/1282091, 8/113903, 15/756400, 4/1282091, 6/1282091, 61/756396, 14/756400, 44/756396, 3/1274586, 43/756396, 6/594041, 6/113903, 48/756396, 62/756396, 42/756396, 45/756396, 47/756396, 5/1282091, 7/594041, 46/756396, 60/756396, 2/44554	14/756400, 42/756396, 62/756396, 3/1282091, 8/113903, 61/756396, 60/756396, 44/756396, 6/594041, 4/1282091, 15/756400, 43/756396, 47/756396, 6/1282091, 48/756396, 6/113903, 3/1274586, 46/756396, 9/113903, 45/756396, 5/1282091, 7/594041	2/44554
5	111/756396, 108/756396, 96/756396, 97/756396, 110/756396, 109/756396	111/756396, 108/756396, 96/756396, 97/756396, 110/756396, 109/756396
6	8/532988, 2/532988, 6/532988, 9/532988, 3/532988, 1/532988, 4/532988, 5/532988, 7/532988	8/532988, 2/532988, 6/532988, 9/532988, 3/532988, 1/532988, 4/532988, 5/532988, 7/532988
7	8/532988, 2/532988, C/TEST, 6/532988, 9/532988, 3/532988, 1/532988, 4/532988, 5/532988, 7/532988, D/TEST	A/TEST, B/TEST, 8/532988, 2/532988, 6/532988, 9/532988, 3/532988, 1/532988, G/TEST, 4/532988, 5/532988, 7/532988	C/TEST, D/TEST	A/TEST, B/TEST, G/TEST
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=TEXTJOIN(", ",TRUE,FILTER(TEXTSPLIT(A2,", "),ISNA(MATCH(TEXTSPLIT(A2,", "),TEXTSPLIT(B2,", "),0)),""))
D2:D7	D2	=TEXTJOIN(", ",TRUE,FILTER(TEXTSPLIT(B2,", "),ISNA(MATCH(TEXTSPLIT(B2,", "),TEXTSPLIT(A2,", "),0)),""))