Help with large data update (Excel)

hüdson

New member
Joined
Jul 2, 2013
Messages
1
Reaction score
0
Points
0
Hi there,

I have a large list of email contacts saved on an excel file (circa 4000). Over time the need to update this list has arisen, as some of these emails no longer work and for some, they have new email adresses. I have the old list, a list of the emails to be deleted, and the list for the emails that should change(this list has both the new and old emails). I am looking for a formula which can easily read the new lists and replace/ delete the required emails.
I am using excel (2007) in German but this is not an issue,
Can anyone Help?


Hüdson
 
Top