Hello everyone, I want to remove all the values in one column from another column.For example:
Column A Column B1111-2222 0123-45672222-1111 6666-55553333-4444 4545-45454444-3333 5656-56565555-6666 2222-11116666-5555 6767-67677777-8888 8989-89898888-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:
How can you do this with Excel?Thank you very much for your help!
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.