|Here's my problem:|
I have 2 columns that contain around 90% same but 10% different values (column A starts from second row A2, column B starts from second row as well B2).
Now, I need to a script or a function that can:
COMPARE column A with B
In column C, write the CELLS which are in column B but NOT in column A.
For example, column A contains the following data: a1, b1, c1, d1, e1
Column B contains the following data: a1, c1, f1, g1
In this case, the data that needs to be in column C is f1 and g1.
Believe me, I've read a lot on this forum and got some software apps to help me do that but all they do is compare on the basis of rows, if data in 2 columns is different in 2 rows, they mark that as a difference. In the previous example, c1 is in column B (2nd row) and b1 is in column A (2nd row.) b1 and c1 are both in row 2 but that doesn't mean something is different. The same data is contained in one cell (doesn't matter where it's located) in both columns so the script/function should treat it as matching data when comparing.