Remove contents of one list from a second list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
See:

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

--


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

Regards,

Peo Sjoblom

RicMurray said:
This seems so basic, but it is eluding me still....I have a list of all
Click to expand...
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?
 
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



RicMurray said:
This seems so basic, but it is eluding me still....I have a list of all
Click to expand...
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?
 
Back
Top