To delete duplicate names in Excel, select the entire list or table, choose Data > Remove Duplicates, select the column or columns that define a duplicate, and confirm. Excel keeps the first matching record and removes later matches, so save a copy first and check which row will be kept before you proceed.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- A list of names, ideally arranged in one column with a header such as Name.
- If names are attached to phone numbers, email addresses, or other details, the complete table range. This lets Excel remove duplicate rows without separating names from their related information.
- A backup copy of the workbook, or a saved copy of the data on another worksheet. The removal changes the selected range, although you can usually undo it immediately.
Step-by-Step
- Decide what counts as a duplicate. A repeated name is not always a repeated person. For example, two different people might both be named Jordan Lee. If you want to remove repeated name entries regardless of other details, use the name column to define duplicates. If you only want to remove records that match in several fields, such as name and email address, use both columns. Decide this before opening the removal tool.
- Save a backup and inspect the data. Save the workbook, or copy the original list to a new worksheet by selecting it, copying it, and pasting it into the other sheet. Check for a header row and make sure the records form a continuous block without completely blank rows or columns breaking it up. If the same name appears several times with different details, note which record you want to retain. Excel keeps the first match it encounters.
- Select the correct range. For a standalone list, click a cell in the name column. For a table with related information, select the whole table, including every column whose row data must stay together. You can click inside a contiguous Excel table and use Ctrl+A to select its data; check the highlighted range before continuing. On Mac, use Command+A. Do not select only the name column inside a multi-column list and proceed with that selection: removing cells without their corresponding details can misalign the records.
- Open Remove Duplicates. On Windows, go to Data > Remove Duplicates in the ribbon. Excel opens a dialog listing the columns in the selected range. If your selection is inside an Excel table, the command is also available from the Data tab. In Excel for Mac, the command is on the Data tab as well, though the ribbon layout and dialog appearance can vary slightly. In Excel for the web, look on the Data tab; if you do not see the command, open the workbook in the desktop app.
- Tell Excel whether the first row is a header. If the first row contains labels such as Name, Email, or City, make sure My data has headers is checked. If the first row is an actual person’s name, leave it unchecked. A wrong setting can cause Excel to treat a real name as a column label or include a header in the duplicate check.
- Choose the columns that determine a duplicate. To remove repeated names even when other columns differ, clear Select All and select only the Name column. Keep the full table selected so that Excel removes the entire matching row, not just a name cell. To remove only records where both the name and email match, select both Name and Email. Excel compares the values in the selected columns as a combination: a repeated name with a different email is then retained. Review the column labels in the dialog so you do not accidentally compare the wrong fields.
- Confirm, review the result, and undo if needed. Click OK. Excel reports how many duplicate values were found and how many unique values remain. Read the message, then check several records in the resulting list, including the first occurrence of a repeated name and the rows around it. If the wrong rows were removed or records no longer line up, press Ctrl+Z on Windows or Command+Z on Mac right away. Undo may not be available after closing the workbook or carrying out other actions, which is why a backup matters.
For example, suppose a table has Name, Email, and City columns. If you select all three columns but select only Name in the Remove Duplicates dialog, Excel keeps the first row for each name and removes later rows with that name, including their email and city. If you select Name and Email instead, two people with the same name but different email addresses remain as separate records. The choice of comparison columns determines the result.
If you want to see a unique list without changing the original data, Microsoft 365 also has the UNIQUE function. With names in A2:A8 and an empty destination cell D2, enter =UNIQUE(A2:A8) in D2. For the sample list Olivia, Liam, Olivia, Noah, Liam, Ava, Noah, the spilled result is Olivia, Liam, Noah, Ava in first-seen order. This creates a separate list; it does not delete any rows from the original. The function is available in Microsoft 365 and Excel 2021 or later.
Common Mistakes
- Selecting only one column of a multi-column record list. The name and its related information must remain on the same row. Select the full table, then use only the Name checkbox to define duplicates if that is your goal.
- Using every column as a comparison. If you leave all columns selected, Excel removes only rows that match across all those columns. Two rows with the same name but different cities or email addresses will remain. That can be correct for duplicate-record cleanup, but not when the aim is one row per name.
- Assuming Excel knows which record is best. It does not choose the newest, most complete, or most accurate details automatically; it retains the first occurrence in the current order. If a particular record should stay, sort the entire table into the desired order before removing duplicates. Never sort just the name column, because that can detach names from their other fields.
- Forgetting the header setting. Check whether the first selected row contains labels. If you are unsure, cancel the dialog, inspect the range, and start again rather than guessing.
- Expecting visually similar text to match. Leading or trailing spaces and invisible characters can make two displayed names different. Differences in capitalization are generally not a reliable way to distinguish records in this tool; do not count on Excel preserving names that differ only by letter case.
Tips
- Make the kept record predictable. If you want the latest entry for each name, sort the whole table by its date column from newest to oldest before running Remove Duplicates. If you want the oldest, sort oldest to newest. Then use the Name column as the comparison field. Confirm the sort applied to the complete table, not just one column.
- Clean inconsistent spacing first. A name with an extra space at the end may not match the same name without it. You can correct obvious stray spaces with Find and Replace or make a cleaned helper column, review it, and use that column for comparison. Do not overwrite the original names until you have checked the cleaned results.
- Use filters or conditional formatting to review before deleting. Highlighting or filtering likely repeats gives you a chance to inspect names that may belong to different people. This is especially useful for common names and lists with contact details. A duplicate indicator is a review aid, not proof that two records describe the same person.
- Keep an untouched source tab for recurring cleanup. Preserve the imported list, make a working copy, and remove duplicates from the copy. This makes it easier to verify a disputed result or repeat the process when a newer export arrives.
- Be cautious with names that contain unusual spaces. Data copied from websites or other systems may contain nonbreaking spaces or other hidden characters. If normal trimming does not resolve a suspected mismatch, compare the source values carefully or paste them into a plain-text editor to inspect what was copied before removing any records.
Troubleshooting
Excel says there are no duplicates, but names look repeated. Confirm that the Name column is checked in the dialog and that the complete range was selected. Look for extra spaces, spelling differences, punctuation, or invisible characters. A name such as “Sam Taylor” may look like another entry but contain a different space character. Clean or correct the values in a helper column, review the result, and run the removal again using the cleaned names.
Some repeated names remain. Check which columns were selected as duplicate criteria. If Name and Email are both checked, a repeated name with a different email is not considered a duplicate combination. If your goal is one row per name, leave Name selected as the criterion while keeping all columns in the selected range. Also check whether the entries are genuinely spelled the same.
Information no longer matches the names. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Re-select the entire record range and run the command again. If undo is unavailable, restore the saved backup or copy the original data back. Avoid trying to reconstruct shifted records by hand unless you can verify every row against the source.
The command is unavailable or the dialog looks different. Make sure a cell in the data range is selected, and check the Data tab. In Excel for the web, a feature or dialog may be presented differently from desktop Excel; opening the file in Microsoft 365 for Windows or Mac is a practical alternative. If the range is protected, ask the workbook owner to allow editing or remove protection if you have permission.
A header or first name was removed unexpectedly. Undo, select the range again, and set My data has headers to match the first row. A label row should be treated as a header; a person’s name in row one should not. Then verify the column list before confirming.
Frequently Asked Questions
Does Remove Duplicates delete the whole row?
When you select the whole table and run the command, Excel removes later rows matching the chosen comparison columns. It keeps the first matching row and its associated values. Selecting an incomplete range can produce a result that does not preserve the record structure, so include all related columns.
Can I delete duplicate names but keep different people with the same name?
Not by comparing names alone. Include a distinguishing field, such as email address or customer ID, in the selected duplicate criteria. If the name and identifier match, Excel treats the combination as a duplicate; if the identifier differs, both records remain.
Will Excel remove duplicates that differ only in capitalization?
Do not rely on capitalization to preserve a separate entry. The duplicate-removal comparison is generally case-insensitive. If capitalization represents a meaningful difference in your data, review and separate those cases using another distinguishing field before deleting.
Can I remove duplicates without permanently changing my source list?
Yes. Copy the data to a separate worksheet or workbook and run Remove Duplicates on that copy. Alternatively, use UNIQUE in Microsoft 365 or Excel 2021 and later to spill a distinct list into an empty area while leaving the source untouched.
Can I undo Remove Duplicates?
Usually, press Ctrl+Z on Windows or Command+Z on Mac immediately after the operation. Undo is not a substitute for a backup, especially if you continue working, close the workbook, or are using a shared or web-based editing session.
Related
- How to Copy in Excel and Keep Formatting
- How to Copy an Image in Excel: Clear Steps and Tips
- Copy Horizontal to Vertical in Excel: Transpose Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Document Not Saved in Excel: Causes and FixesIf Excel says “Document not saved,” first protect your changes: use File > Save As > Browse to…
- Excel Date Greater Than Date? Compare Dates in CellsTo check whether one Excel date is later than another, use the greater-than operator: with the first date…
- Cut, Copy, and Paste in Excel: Shortcuts and StepsTo cut, copy, or paste in Excel for Microsoft 365 on Windows, select the cell or range and…
- Rate Quotation Format in Excel: A Practical GuideA rate quotation in Excel is an itemized document that shows what you will charge for specified goods…
- Merge Cells in Excel: Keyboard Shortcuts and StepsIn Excel for Microsoft 365 on Windows, select the cells and press Alt+H, M, C—one key sequence at…
- Unblock a Sender in Outlook: App and Desktop StepsTo unblock a sender in Outlook, remove their email address or domain from Outlook’s blocked-senders list; in new…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.