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
surah79Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
cynxConnect With a Mentor Commented:
I have written macro to do the same. assigned it to button on worksheet.
file attached.


Test.xls
0
 
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
 
surah79Author Commented:
Thanks a million for your help Apologies for replying you so late
0
All Courses

From novice to tech pro — start learning today.