Improve company productivity with a Business Account.Sign Up

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

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
Asked:
surah79
1 Solution
 
ukerandiCommented:
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
 
cynxCommented:
I have written macro to do the same. assigned it to button on worksheet.
file attached.


Test.xls
0
 
surah79Author 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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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