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
|