Remove contents of one list from a second list

[RicMurray]

This seems so basic, but it is eluding me still....I have a list of all registered users to our website. I have a list of all the users who logged in for an event. I want to e-mail those who did NOT attend. How can I easily subtract one list from a larger one?

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

 

[Peo Sjoblom]

See:

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

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

This seems so basic, but it is eluding me still....I have a list of all

registered users to our website. I have a list of all the users who logged
in for an event. I want to e-mail those who did NOT attend. How can I easily
subtract one list from a larger one?

 

[CLR]

I would use a Helper column and write a VLOOKUP foumula to look up each name
in the second list to see if it was on the first list and copy the formula
down.........then either sort, or use AutoFilter to get the result..........

hth
Vaya con Dios,
Chuck, CABGx3

This seems so basic, but it is eluding me still....I have a list of all

registered users to our website. I have a list of all the users who logged
in for an event. I want to e-mail those who did NOT attend. How can I easily
subtract one list from a larger one?