how do i find the names?

[Dee]

What is the fastes way for finding repetition of names in a document e.g. I
have over 20,000 names in a table and need to crosscheck that each name
appeared only once

 

[CyberTaz]

You won't find any such feature in a word processing program (AFAIK). What
you are looking for is a database management functionality. Depending on how
the file is structured you may be able to convert it to and/or save it in a
format that would enable using Excel or some database program to find the
duplication.

 

[John McGhie]

Hi Dee:

The usual way to do this is to sort the table.

If you want to get the table back into order afterwards, add a column to it,
and add numbers to the column. Then convert the numbers to text BEFORE you
sort.

Then sort the table by the names. You will see at a glance if you have any
duplicates. Remove them.

Then sort the table again, this time by the numbered column. That will put
it back in order.

Then delete the numbered column.

If you do not want to use a numbered column, make a copy of the document,
sort the table, identify the duplicates, and remove them from the original.

Hope this helps

What is the fastes way for finding repetition of names in a document e.g. I
have over 20,000 names in a table and need to crosscheck that each name
appeared only once

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]