Sep 13 2020 09:56 AM
Hello everyone, I want to remove all the values in one column from another column.
For example:
Column A Column B
1111-2222 0123-4567
2222-1111 6666-5555
3333-4444 4545-4545
4444-3333 5656-5656
5555-6666 2222-1111
6666-5555 6767-6767
7777-8888 8989-8989
8888-7777 5544-5544
What I'm looking for is that the matches in column A are deleted from column B. In this case the Column A would be like this:
1111-2222
3333-4444
4444-3333
5555-6666
7777-8888
8888-7777
How can you do this with Excel?
Thank you very much for your help!
Best regards,
Gabriel
Sep 13 2020 10:17 AM
If delete matched values in cells, that's with VBA programming.
If generate new column without matched values that could be like
If generate new column with empty cells instead of matched values, that could be formula, just bit more complex.