Comparing prospect and buyers lists

I am trying to help out our marketing department and so far the only thing I
have accomplished is to turn myself into a drooling idiot.

My problem: We have two worksheets, the first is a list of names/emails of
prospects and the second is a list of names/emails of people who have
actually bought our product. Marketing wants to send an email to the people
on the prospects list that are NOT already buyers.

How can I compare the two lists, removing the names that are buyers but
otherwise leaving the prospect list intact?

I am using Office 2003.

Thanks for the help

I would suggest copying it to another worksheet.

On the prospects list, in column C add a formula of

=IF(COUNTIF('buyers'!$A$2:$A$100,A2)>0,"","Prospect")

and copy down.

Then either
- filetr the data based on a value of Prospect (Data>Filter>Autofilter) and
copy the visible rows to another worksheet
- copy the rows using advanced filter (Data>Filter>Advanced Filter) using a
criteria of 'Prospect' to another worksheet

--

HTH

RP
(remove nothere from the email address if mailing direct)


"twd" <twd@discussions.microsoft.com> wrote in message
news:474578EE-D95E-4290-B4B1-26CCC9760DA9@microsoft.com...
> I am trying to help out our marketing department and so far the only thing
I
> have accomplished is to turn myself into a drooling idiot.
>
> My problem: We have two worksheets, the first is a list of names/emails of
> prospects and the second is a list of names/emails of people who have
> actually bought our product. Marketing wants to send an email to the
people
> on the prospects list that are NOT already buyers.
>
> How can I compare the two lists, removing the names that are buyers but
> otherwise leaving the prospect list intact?
>
> I am using Office 2003.
>
> Thanks for the help

That worked, thanks a bunch.

"Bob Phillips" wrote:

> I would suggest copying it to another worksheet.
>
> On the prospects list, in column C add a formula of
>
> =IF(COUNTIF('buyers'!$A$2:$A$100,A2)>0,"","Prospect")
>
> and copy down.
>
> Then either
> - filetr the data based on a value of Prospect (Data>Filter>Autofilter) and
> copy the visible rows to another worksheet
> - copy the rows using advanced filter (Data>Filter>Advanced Filter) using a
> criteria of 'Prospect' to another worksheet
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "twd" <twd@discussions.microsoft.com> wrote in message
> news:474578EE-D95E-4290-B4B1-26CCC9760DA9@microsoft.com...
> > I am trying to help out our marketing department and so far the only thing
> I
> > have accomplished is to turn myself into a drooling idiot.
> >
> > My problem: We have two worksheets, the first is a list of names/emails of
> > prospects and the second is a list of names/emails of people who have
> > actually bought our product. Marketing wants to send an email to the
> people
> > on the prospects list that are NOT already buyers.
> >
> > How can I compare the two lists, removing the names that are buyers but
> > otherwise leaving the prospect list intact?
> >
> > I am using Office 2003.
> >
> > Thanks for the help
>
>
>