LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I filter names in Excel to eliminate repeats? Scott Excel Discussion (Misc queries) 1 May 3rd 06 05:54 PM
msquery odbc -- excel repeats query on return [email protected] Excel Discussion (Misc queries) 0 April 3rd 06 06:22 PM
function for finding repeats in a column... killertofu Excel Worksheet Functions 2 February 21st 06 08:03 PM
excel/some text auto repeats in same columb others don't why. P.G.C. Excel Worksheet Functions 1 October 20th 05 06:17 PM
no repeats in a column repeat Excel Worksheet Functions 2 November 3rd 04 09:36 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"