Locate data from 1 column in another

[Shaz]

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?

 

[Jacob Skaria]

Assuming your data starts from A1 use the below formula in B1...which will
return "Present" if present in colD.

=IF(TRIM(A1)=D,"Present","")

If this post helps click Yes

 

[Teethless mama]

In E2=IF(COUNTIF(D,A2),"present","")

Auto Filter the blanks in Column E and delete