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