Replace multiple values in columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1661999%22%20slang%3D%22en-US%22%3EReplace%20multiple%20values%20in%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661999%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20I%20want%20to%20remove%20all%20the%20values%20in%20one%20column%20from%20another%20column.%3CBR%20%2F%3EFor%20example%3A%3C%2FP%3E%3CP%3EColumn%20A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Column%20B%3CBR%20%2F%3E1111-2222%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%200123-4567%3CBR%20%2F%3E2222-1111%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%206666-5555%3CBR%20%2F%3E3333-4444%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%204545-4545%3CBR%20%2F%3E4444-3333%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%205656-5656%3CBR%20%2F%3E5555-6666%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%202222-1111%3CBR%20%2F%3E6666-5555%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%206767-6767%3CBR%20%2F%3E7777-8888%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%208989-8989%3CBR%20%2F%3E8888-7777%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%205544-5544%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I'm%20looking%20for%20is%20that%20the%20matches%20in%20column%20A%20are%20deleted%20from%20column%20B.%20In%20this%20case%20the%20Column%20A%20would%20be%20like%20this%3A%3C%2FP%3E%3CP%3E1111-2222%3CBR%20%2F%3E%3CBR%20%2F%3E3333-4444%3CBR%20%2F%3E4444-3333%3CBR%20%2F%3E5555-6666%3CBR%20%2F%3E%3CBR%20%2F%3E7777-8888%3CBR%20%2F%3E8888-7777%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20you%20do%20this%20with%20Excel%3F%3CBR%20%2F%3EThank%20you%20very%20much%20for%20your%20help!%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EGabriel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1661999%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1662026%22%20slang%3D%22en-US%22%3ERe%3A%20Replace%20multiple%20values%20in%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1662026%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F792007%22%20target%3D%22_blank%22%3E%40_neok%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20delete%20matched%20values%20in%20cells%2C%20that's%20with%20VBA%20programming.%3C%2FP%3E%0A%3CP%3EIf%20generate%20new%20column%20without%20matched%20values%20that%20could%20be%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20520px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F218042iCD36B1E1D586C911%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20generate%20new%20column%20with%20empty%20cells%20instead%20of%20matched%20values%2C%20that%20could%20be%20formula%2C%20just%20bit%20more%20complex.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply

@_neok 

If delete matched values in cells, that's with VBA programming.

If generate new column without matched values that could be like

image.png

If generate new column with empty cells instead of matched values, that could be formula, just bit more complex.