Finding repeats in Excel
 

Hi everyone,
I have a large, large database at my work, where we input names and
related data. There're at least 3000 names and many people work on the
same file.

Now we want to find repeats, repeat names and remove that data, since
we dont want it to factor into stats.
But the problem is we dont know which names repeat and which dont.

Is there any way all to find out which names repeat (in the same
column) and if so, how can I do that, without typing in each name in
the Find option?

Thanks for your help,

Prac

Finding repeats in Excel
 

If you want to keep just one instance of each name and associated data, use
DataFilterAdvanced FilterUnique records only and "Copy to a new location"

To copy to another sheet see Debra Dalgleish's site for more info.

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


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 12:31:13 -0700 (PDT), wrote:

Hi everyone,
I have a large, large database at my work, where we input names and
related data. There're at least 3000 names and many people work on the
same file.

Now we want to find repeats, repeat names and remove that data, since
we dont want it to factor into stats.
But the problem is we dont know which names repeat and which dont.

Is there any way all to find out which names repeat (in the same
column) and if so, how can I do that, without typing in each name in
the Find option?

Thanks for your help,

Prac