Lets say I have cells in row A that have text data
1 Blue
2 Blue Submarine
3 Red Lagoon
4 Green hornet
I want excel to compare cell value of all cells and copy cells that are entirely duplicate or part of 1 cell that is duplicate of part of some other cell like in A1 A2, to column b. Only cells that contain identical values of minimum 9 chars should be copied over to adjecent cell, so I wouldnt get copied cells of (a, the, of) or numbers like eg. A1 - 23 A2-232 giving a positive match.
So the end result would be
------A--------------- B
1 Blue------------- Blue
2 Blue horizon------ Blue horizon
3 Red Lagoon
4 Green hornet
I have 36527 rows atm
Is this possible?
1 Blue
2 Blue Submarine
3 Red Lagoon
4 Green hornet
I want excel to compare cell value of all cells and copy cells that are entirely duplicate or part of 1 cell that is duplicate of part of some other cell like in A1 A2, to column b. Only cells that contain identical values of minimum 9 chars should be copied over to adjecent cell, so I wouldnt get copied cells of (a, the, of) or numbers like eg. A1 - 23 A2-232 giving a positive match.
So the end result would be
------A--------------- B
1 Blue------------- Blue
2 Blue horizon------ Blue horizon
3 Red Lagoon
4 Green hornet
I have 36527 rows atm
Is this possible?
Last edited:
