DEDUPING RECORDS

[Corrine Hayden]

I will be merging two spreadsheets, and I would like to
know how I can get rid of duplicate records.

Regards,
Corrie

 

[Norman Harker]

Hi Corrine!

Try visiting:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#

All that you probably need for handling unique and duplicate record
problems. Also, it's worth going down to the bottom of the page and
clicking on Topic Index as the Topic page will be a useful one to make
a favorite.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 4th August 2003: British Virgin
Islands, Dominica, Eire, Montserrat, St. Kitts & Nevis, St. Vincent &
Grenadines, UK (August Holiday), Anguilla (Carnival), Bahamas
(Emancipation Day), Barbados (Kadooment), Burkina Faso (Revolution
Day), Canada (British Columbia Day, New Brunswick Day, Natal Day),
China (Chinese Valentine's Day), Cook Islands (Constitution Day), El
Salvador (Transfiguration Day), Guyana (Freedom Day), Iceland (Workers
Day), Peru (Anniv Huancavelica), Zambia (Farmer's Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Phil Ragan]

assuming you are merging two databases in Excel into one:
do that first, then
extract the database into a second sheet using the
Data - Advanced Filter selection, but select the "Unique
records only" option which will filter out duplicates.
Phil