Locate data from 1 column in another
 

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?

Locate data from 1 column in another
 

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
---------------
Jacob Skaria


"Shaz" wrote:

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?

Locate data from 1 column in another
 

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

Auto Filter the blanks in Column E and delete



"Shaz" wrote:

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?