Finding repeats in Excel

[pracprofalc]

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

 

[Gord Dibben]

If you want to keep just one instance of each name and associated data, use
Data>Filter>Advanced Filter>Unique 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/xladvfilter01.html#FilterUR


Gord Dibben MS Excel MVP