I have a database of 3000 names and email addresses which i have pasted into a worksheet. Every day I paste an extra column into this worksheet containing around 200 names of customers whose orders have been despatched.
I need to to match up those names of the extra column with the database names so I can find the email addresses of those customers
If i find duplicates it will find duplicates in the actual database columns (example A1:A2000) instead/and over the two unique columns (A1:A:2000,C1:C2000) I also cannot get these duplicates to align themselves up against each other instead of just highlighting where they lie.
I am not familiar with finding duplicates so my examples may also be wrong but i hope it's clear enough that someone can help me figure out how to do this
Bookmarks