MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How To Find and Delete Duplicate Entries In My Numbers Document?

I am typing a new notebook for Karaoke. Therefore I have 3 columns. Column A is the track name, Column B is the Artist and Column C is the track number for my reference in location of the song. I have duplicate entries and need to remove these. The problem is say for example we have:
Rolling in the deep….Adele…..PKS45-2
Rolling in the deep….Adele…..SDS23-6
Rolling in the deep….Adele…..SDS23-6
The first 2 rows need to stay, even though they are the same song, they are different versions on separate cd’s. But as you can see the 3rd row is a duplicate of the 2nd row. I do not know how this happened when importing this info from PAGES, but this is going to be the death of me and Apple CARE says they only do software issues not user incompetence. So how do I create a formula or do something to delete these duplicates like row 3 without mainly going through one row at a time and doing it cause I have thousands of songs.

Comments: One Response to “How To Find and Delete Duplicate Entries In My Numbers Document?”

    11 years ago

    Here's how I would do it.
    Sounds like the column C is the only one you need to worry about. If that matches another row, then you have a duplicate, right?
    So I would first sort by column C. Now any duplicates must be one after the other.
    In column D, row 2 I would put the formula =IF(C2=C1,1,0)
    This will check to see if the value in column C is the same as the value just above it in column C. It will show a 1 if it is, and a 0 if not.
    Now copy and paste that formula into cells D3 to DX (all of the remaining cells in column D). So you get 0s and 1s, with the 1s indicating duplicates.
    Now the tricky part. Select all of the values in D. Copy. Then use Edit, Paste Values. This removes the formulas and replace them with the actual 0s and 1s. These values won't change now when you do the next step.
    Sort by column D. Now all of the duplicates are together in a group with the value 1 in column D. You can select and delete them.
    Then re-sort in whatever order you like.

Comments Closed.