Prev: How to change default font color in Excel 2007?
Next: Splitting Equals
From: Phil C. Phil on 14 Apr 2010 06:47
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??
From: Jacob Skaria on 14 Apr 2010 06:56
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??
From: Gord Dibben on 14 Apr 2010 10:19
Jacob

A little late but congratulations on MVP status.


Gord

On Wed, 14 Apr 2010 03:56:01 -0700, Jacob Skaria
<JacobSkaria(a)discussions.microsoft.com> 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")

 | 
Pages: 1
Prev: How to change default font color in Excel 2007?
Next: Splitting Equals