ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Finding duplicate records in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/2413-finding-duplicate-records-excel.html)

KG

Finding duplicate records in Excel
 
I know how to find duplicate records in Access but, for a broad-range project
that I shall be working on Excel, is the way I want to go. I shall be mergind
data from various sources and I will want to find and eliminate duplicate
entries.

I did not find any answers under Google groups. Can someone point me to
reference material(s) regarding this topic?

Gord Dibben

KG

http://www.contextures.on.ca/xladvfi....html#FilterUR

http://www.cpearson.com/excel/duplicat.htm

And from Google search......

http://snipurl.com/bjjc

Gord Dibben Excel MVP

On Wed, 22 Dec 2004 11:15:01 -0800, "KG" wrote:

I know how to find duplicate records in Access but, for a broad-range project
that I shall be working on Excel, is the way I want to go. I shall be mergind
data from various sources and I will want to find and eliminate duplicate
entries.

I did not find any answers under Google groups. Can someone point me to
reference material(s) regarding this topic?



Frank Kabel

Hi
see:
http://www.cpearson.com/excel/duplicat.htm


--
Regards
Frank Kabel
Frankfurt, Germany

KG wrote:
I know how to find duplicate records in Access but, for a broad-range
project that I shall be working on Excel, is the way I want to go. I
shall be mergind data from various sources and I will want to find
and eliminate duplicate entries.

I did not find any answers under Google groups. Can someone point me
to reference material(s) regarding this topic?





All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com