Hi Jacob

Thanks for this idea. Can I change this formula so that it removes the 1000
names and just leaves me with a datasheet with 1,265 names?

Thanks

Phil



"Jacob Skaria" wrote:

With data in Sheet1 (2265) and Sheet2 (1000) ; apply the below formula in
Sheet1 cell B1 and copy down to row 2265.....

=IF(COUNTIF(Sheet2!A:A,A1),"","Mail to be sent")

--
Jacob (MVP - Excel)


"Phil C." wrote:

I have a mailing list of 2,265 names. Someone has randomly seleceted 1,000
names from the list and mailed them. I need to mail the other 1,265.

I have two Excel workbooks with 2,265 names in one and 1,000 in the other.

I need to be able to subtract the data in the smaller workbook from the
larger one.

Any ideas please??