Solved

# Excel Sort and Remove

Posted on 2011-09-30
Medium Priority
287 Views
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
Question by:surah79
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 10

Expert Comment

ID: 36890606
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

LVL 1

Accepted Solution

cynx earned 2000 total points
ID: 36890626
I have written macro to do the same. assigned it to button on worksheet.
file attached.

Test.xls
0

Author Closing Comment

ID: 36907543
Thanks a million for your help Apologies for replying you so late
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilâ€¦
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
###### Suggested Courses
Course of the Month11 days, 18 hours left to enroll