x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 301

# Excel Sort and Remove

Hi All

I have two columns in Excel and want to compare the number in both the column,
Eg Column A and Column B . compare the number from Column B to A, if the matching number found in A Delete the number from Column B.
Colmun A has the number 004523600924 abd Column B has the number 452360 and now this is the match so we need to delete this number from the Column B

Any help will be appreciated

Thanks

Test.xls
0
surah79
1 Solution

Commented:
for example in Column A has 23 and Column B has 123 then results will be in the Column B is 1. is it correct?
0

Commented:
I have written macro to do the same. assigned it to button on worksheet.
file attached.

Test.xls
0

Author Commented:
Thanks a million for your help Apologies for replying you so late
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

## Featured Post

Tackle projects and never again get stuck behind a technical roadblock.