I have 500 email addresses in column D and 13,000 in column A. Now i want to
delete all of the column A except the ones which are also in column D.

in other words I want to locate 500 contacts within our entire database of
13,000 checking it on email address. Can any body help please?