In cell C1 apply the below formula and copy/drag down as required...Once done
Copy ColCRight click PasteSpecialValues to convert formulas to
values...Sort data wrt ColC and delete the records in ColB for which ColC is
blank

=IF(COUNTIF(A:A,B1),"Exist","")

Col A Col B Col C
1011 1011 Exist
1012 1015 Exist
1013 1002
1015 1005
1013 Exist
1015 Exist


--
Jacob


"kix" wrote:

I have two columns 1st column has certain account numbers, the 2nd has those
same numbers plus a couple hundred more. I want to eliminate the account
numbers in 2nd column that do not exist in 1st column. I don't know how to
write a
formula for this.

Thank you.