finding duplicate entries in pages doc...

i've got a huge pages document with email addresses.

is there a simple way to scan the document for dupes?


anyone??


thx!

Posted on Mar 14, 2012 8:17 PM

Reply
4 replies

Mar 14, 2012 9:17 PM in response to fisherKing

If the email addresses are all that is in the document, they are in a list, and you also have Numbers, the following will work:


  • Select all of the list. Copy
  • Launch Numbers and open a new, blank document.
  • Click on cell B2 of the table in Numbers. Paste.
    Your addresses should fill column B, with rows added to the table as necessary.
  • Enter this formula into C2: =IF(COUNTIF($B$1:B2,B2)>1,"DUP","")
    (The result in C2 should appear to be an empty cell.)
  • Click on the Column Reference tab for column C to select the whole column, then
    Command-click on cell C1 to remove it from the selection.
  • Go Insert (menu) > Fill > Fill Down.
    Your table will now resemble this one, with duplicate entries marked in column C:
    User uploaded file
  • With column C still selected, Copy, then go Edit > Paste Values.
    This replaces the formulas in column C with the values calculated by that formula.
  • Click the Reorganize button, then in the Sort section, choose Column C.
    The table will be sorted, bringing all the DUP entries together at the top of the table.
  • Select all of the rows containing DUP (Click on the Row Reference tab of the first, then shift-click on the Row reference tab of the last) to select all of the rows containing duplicate addresses.
  • Go Table > Delete Rows.
  • Select the column containing the email addresses. Copy.
  • Return to the Pages document. Paste.
  • Done


Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

finding duplicate entries in pages doc...

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.