Comparing 2 columns for duplicates

[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!

 

[Dave Peterson]

You could use Data|Filter|advanced filter to obtain a unique list.

Debra Dalgleish has a nice explanation at:
http://www.contextures.com/xladvfilter01.html#FilterUR

And then you could use some techniques at Chip Pearson's to see if that person
is on both lists:

http://www.cpearson.com/excel/duplicat.htm

 

[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.