Comparing 2 columns for duplicates

S

stubin

Hi,

I have 2 lists, in col A is a list of all employees, in col B is a list
of all occurances of missed time. Some people may appear in the second
list many times. I need to remove all duplicate entries and be left w/
a list of employees who did not miss any time. I am currently running a
VBA macro to do this, but it takes 10-15 minutes to complete....

If you would like a sample of the code I'm using, just ask and I'll
post it.
Thanks!
 
M

Myrna Larson

I'm not completely clear on what you have in column B, but assuming it's
names, you could use a helper column, say C, with this formula
=COUNTIF(A2,$B$2:$B$100)

I've assumed you have headers in row 2. Adjust the reference to column B as
needed. Than you can filter on column B for values of 0.
 
Top