Locate data from 1 column in another

  • Thread starter Thread starter Shaz
  • Start date Start date
S

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?
 
Assuming your data starts from A1 use the below formula in B1...which will
return "Present" if present in colD.

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

If this post helps click Yes
 
In E2=IF(COUNTIF(D:D,A2),"present","")

Auto Filter the blanks in Column E and delete
 
Back
Top