View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] pracprofalc@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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