Re: Merging two spreadsheets, avoiding duplicates?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: George K (gekyruk_at_NOSPAM.yahoo.co.uk)
Date: 03/21/04 

Date: Sun, 21 Mar 2004 11:43:59 -0000

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
> > >
> > >
> >
>
>

Quantcast