Subtracting results

[kerrysr]

Say I have 20 new cusomers without catalogs and 15 customers with catalogs. Is there a way I can tell excel to subtract the without group from the with and show me which do not have catalogs? In other words only show the list the hasnt received catalogs. Also, would this be easier to send the excel data to access and have access do this?
Thanks

 

[eliW]

On 2002-04-18 07:50, kerrysr wrote:
Say I have 20 new cusomers without catalogs and 15 customers with catalogs. Is there a way I can tell excel to subtract the without group from the with and show me which do not have catalogs? In other words only show the list the hasnt received catalogs. Also, would this be easier to send the excel data to access and have access do this?
Thanks

kerrysr,
I assume that your data is like this:
In column A - customers name.
In column B - indicator for having catalog e.g. Y/N or 0/1.
You can now use AutoFilter on column B to show only rows of customers which hasn't received catalogs.
from toolbar click: Data | Filter | AutoFilter - and choose ctegory for column B.
Eli