how do i compare two columns and remove duplicates?

[aljernon805]

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.

 

[gls858]

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/duplicat.htm#HighlightingDuplicates

gls858