Re: Merging two spreadsheets, avoiding duplicates?

From: Gord Dibben (gorddibbATshawDOTca)
Date: 03/21/04 

Date: Sun, 21 Mar 2004 09:51:53 -0800

George

Given the data in your example and the fact you want to send one and only one
email to each company, I would filter or tag on column A. This column has the
duplicated company names.

You would wind up with a list of unique company names, with one contact and
email for each company.

If you want a particular person(column B) as a contact for each company, I am
afraid you would be forced to manually delete the extra persons. Sort on
Column A and pick the persons per company you don't want and delete those
rows.

The email column C has no duplicates to filter or tag.

Gord

On Sun, 21 Mar 2004 11:43:59 -0000, "George K" <gekyruk@NOSPAM.yahoo.co.uk>
wrote:

>Thanks guys.
>
>Gord, i 'll try what you said on Monday. Thanks.
>
>However, what is still unclear in my head is the criteria for duplication.
>What does it assume as a duplicate?
>
>Example:
>
>COMPANY NAME EMAIL
>Ribas John Smith js@ribas.com
>Ribas Helen Brown hb@ribas.com
>Citibank John Smith j.smith@citigroup.com
>etc
>
>If you take a look, the company name repeats as we have more than one name
>for each company, and some names may coinside to be the same. Like "John
>Smith". Easy in 6000 names. So, the email column is the proper criterion for
>uniqueness.
>
>What i understood from Dave Hawley's reply is that i would have to keep the
>one column of interest, the EMAIL in my case, and search for duplicates in
>there. If i do that, how would i know whose is each email that remained
>after the process. I would have to add the corresponding name and company
>name next to each email.
>
>I need to have them together and for every duplicate email, delete the whole
>corresponding row.
>
>Does that make sense?
>
>Thanks again,
>
>George
>
>
>
>
>
>
>"George K" <gekyruk@NOSPAM.yahoo.co.uk> wrote in message
>news:eTde2stDEHA.3748@TK2MSFTNGP11.phx.gbl...
>> Hi Gord,
>>
>> Is there any other way? I tried to do it and it does reduce the rows
>meaning
>> it filters out data. However, i don't understand what criterion it uses to
>> filter out data. Also, whether i clicked "unique " or not, again data were
>> filtered. i don't understand how it works. I would like to use the email
>> uniqueness as the criterion for duplication. Because i know we only have 1
>> email per name. Not any other column.
>>
>> I need to be 1000% sure about this. Sending an email twice even to few of
>> the 1600 common top financial names would be a good reason to "not be
>> needed" in the company anymore...
>>
>> Could you please help me in more detail?
>>
>> Thanks,
>> George
>>
>>
>>
>>
>>
>>
>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> news:pv8p501njl2qdft46iatop9r4tgt82ejcb@4ax.com...
>> > George
>> >
>> > I would transfer(copy) the smaller list to below the larger list then
>use
>> > Filtering to pull out the unique names/addresses.
>> >
>> > For instructions on the filtering part see Debra Dalgleish's site.
>> >
>> > http://www.contextures.on.ca/xladvfilter01.html#FilterUR
>> >
>> > Gord Dibben Excel MVP
>> >
>> > On Sat, 20 Mar 2004 19:19:06 -0000, "George K"
>> <gekyruk@NOSPAM.yahoo.co.uk>
>> > wrote:
>> >
>> > >I have two excel spreadsheets that each contains the following fields:
>> > >Company name, Contact name, email address.
>> > >
>> > >The first is 1600 lines long, and the second about 6000 lines long. All
>> 1600
>> > >entries of the first one exist in the second spread***.
>> > >
>> > >My company emailed the names of the first list but afterwards we
>decided
>> we
>> > >had to email more people and exported all our contacts to make the
>second
>> > >6000-name long list. Now we have to make sure we don't email the same
>> people
>> > >twice. So, is there a way to subtract the entries that exist in the
>first
>> > >one from the second? Could we use the Email column as the criterion to
>> judge
>> > >if the name exists or not?
>> > >
>> > >Thank you. George
>> > >
>> > >
>> >
>>
>>
>