how do i compare two columns and remove duplicates?
 

i need to repeat a specific function almost daily. i have two coulums of 10
digit numbers. a is about 10 k to 60 k. b is usually less than 10 k. i
want to search a for the sets of numbers in b. when found i need to elimnate
them from both colums.

i am a beginner in excel. i believe a macro can do this but have no idea
how to create one.

how do i compare two columns and remove duplicates?
 

aljernon805 wrote:
i need to repeat a specific function almost daily. i have two coulums of 10
digit numbers. a is about 10 k to 60 k. b is usually less than 10 k. i
want to search a for the sets of numbers in b. when found i need to elimnate
them from both colums.

i am a beginner in excel. i believe a macro can do this but have no idea
how to create one.


Take a look at this excellent site provided by Pearson Software

http://www.cpearson.com/excel/duplic...tingDuplicates

gls858