How to Find Repeat Names in Excel Quickly and Clearly

To find repeat names in Excel, select the name cells and choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. To identify repeats with a formula instead, put names in A2:A100 and enter =COUNTIF($A$2:$A$100,A2)>1 in B2, then fill it down. The highlight is the quickest visual check; the formula gives you a filterable TRUE/FALSE result and more control.

What You’ll Need

An Excel workbook and a list of names in one column. The examples below use names in A2:A100, with a header in A1.
A spare column if you want formula results beside the names. You can also use Conditional Formatting without adding a column.
A quick decision about what counts as a repeat: an exact full-name match, or names that are similar but may have different spelling, spacing, or punctuation.

The instructions are for Excel for Microsoft 365 on Windows. The main methods are also available in Excel for Mac and Excel for the web, though some ribbon labels or dialog layouts can differ slightly. Formulas below use commas as argument separators.

Step-by-Step

Prepare the name list. Put one name in each cell in a single column, with a clear heading such as Name in A1. Keep the header out of the range you check. Remove completely empty rows inside the list if practical, and avoid selecting unrelated data next to the names. If your list is in another column, use that column in place of A in the steps below.
Highlight duplicates without a formula. Select the cells containing names, such as A2:A100. On Windows, go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. In the dialog, make sure Duplicate is selected, choose a format from the list, and select OK. Excel applies the chosen formatting to values it identifies as repeated within the selected range. Look through the highlighted cells to review the matches.
Check the rule’s scope. If you selected only A2:A100, Excel checks for repeats in that range, not elsewhere in the workbook. To check a longer list, select the full populated range before applying the rule. If you add names later, the new cells may not be covered; edit the rule or reapply it to include the additions. In the Conditional Formatting Rules Manager, check the Applies to range if the highlighting appears incomplete.
Add a formula that marks every occurrence of a repeated name. This is useful when you want to filter or sort the results. With names in A2:A100 and the formula going in B2, enter =COUNTIF($A$2:$A$100,A2)>1. This returns TRUE when the name in A2 appears more than once in the full list, and FALSE when it appears once. Fill the formula down through B100 by dragging the fill handle or copying and pasting. The dollar signs keep the list range fixed as the formula is copied, while A2 changes to A3, A4, and so on.
Filter to the repeated names. Select the list and the new results column, including the headings, then choose Data > Filter. Open the filter arrow in the formula-results heading and select TRUE. The remaining rows are names that appear more than once. You can use the same filter on a larger table, but include the related columns when selecting it so each person’s other details stay on the correct row.
Mark only the later occurrences, if that is what you mean by repeat. Sometimes the first appearance is the original record and you only want to flag subsequent appearances. With names in A2:A100 and the formula in B2, enter =COUNTIF($A$2:A2,A2)>1 and fill it down to B100. The expanding range counts from the first name cell to the current row. For example, if “Jordan Lee” appears in A2, A8, and A20, the results for those rows are FALSE, TRUE, and TRUE. In contrast, the previous formula marks all three occurrences TRUE.
Count how many times each name occurs. A count can help distinguish a name that occurs twice from one that occurs many times. With names in A2:A100 and the formula in B2, enter =COUNTIF($A$2:$A$100,A2) and fill down. Each row displays the total number of times its name occurs in the checked range. A result of 1 means no repeat; a result of 2 or more means there is at least one other matching entry. Filter the count column for values greater than 1 to see the repeated records.
Use a formula-based highlight when you need to exclude blanks. The built-in Duplicate Values rule is convenient, but a formula gives you a direct way to specify that empty cells should not be flagged. Select A2:A100, choose Home > Conditional Formatting > New Rule, and select Use a formula to determine which cells to format. With A2:A100 selected and A2 as the active cell, enter =AND(A2<>"",COUNTIF($A$2:$A$100,A2)>1). Choose Format, set a fill or font style, and select OK. The relative A2 reference checks each cell in the selected range; the fixed range remains the comparison list. In Excel for Mac, the same rule is available through Home > Conditional Formatting, though the dialog wording can vary by release.
Review the matches before changing the data. A duplicate is a matching cell value, not proof that two records refer to the same person. Compare other details, such as an email address or customer number, before deleting anything. If the task is simply to identify repeated entries, leave the original list intact and use the highlights or filter results as a review list.

For example, if A2:A6 contains “Morgan Price,” “Avery Chen,” “Morgan Price,” “Sam Rivera,” and “Avery Chen,” the first COUNTIF formula returns TRUE for both Morgan rows and both Avery rows, and FALSE for Sam. The count formula returns 2 for Morgan and Avery and 1 for Sam. This lets you verify that the method is finding values that match the actual cells, rather than relying on a visual guess.

Common Mistakes

Selecting the heading as part of the data. If a heading such as Name is included, it can be treated as a value. Start the check at the first name cell, usually A2, rather than A1.
Checking only the visible part of a long list. A repeat outside the selected range will not be found. Expand the range to cover all relevant rows, including records below the current screen.
Assuming similar-looking names are identical. Excel checks cell values, not whether two people are probably the same. “Ana Marie” and “Ana-Marie” are different text, as are “Lee, Jordan” and “Jordan Lee.” Decide how to handle variants before removing records.
Deleting every highlighted row. A duplicate rule highlights all matching occurrences, including the first one. Deleting all highlighted entries could remove every copy. Check which record to keep, or use the formula that marks only later occurrences as a review aid.
Overwriting the source names with results. Put formulas in a separate column so the original list remains available for comparison and correction.
Expecting the formula to be case-sensitive. COUNTIF is not case-sensitive in this use. For example, it treats “morgan price” and “Morgan Price” as matching text. If capitalization distinguishes records in your process, use a more specialized comparison rather than relying on COUNTIF alone.

Tips

Clean extra spaces before checking. A leading or trailing space can make a name fail to match an otherwise identical entry. With names in A2:A100 and a cleanup formula in B2, enter =TRIM(A2) and fill it down. TRIM removes leading and trailing spaces and reduces repeated ordinary spaces between words. Review the cleaned results, then use that helper column as the list to check. TRIM does not standardize punctuation or correct spelling.
Check the full name, not just one part. If first names and surnames are in separate columns, create a helper value that combines them. With first names in A2:A100, surnames in B2:B100, and the combined result in C2, enter =A2&" "&B2 and fill down. Then apply the duplicate check to C2:C100. This compares the combined text, so use consistent name order and spelling.
Keep a backup before cleaning the list. Filtering and highlighting are reversible, but deleting rows or replacing values can be harder to undo after more edits. Save a copy before making substantial changes, and review a filtered set of possible repeats before removing records.
Use a table for a growing list. Select the data and choose Insert > Table if you want a structured list that can expand as you add records. After adding rows, check that your formula column and conditional-formatting rule extend to the new entries. Do not assume an existing fixed range such as A2:A100 automatically includes every future row.

Troubleshooting

No names are highlighted. Confirm that the selected range contains the names, not a blank column or only the heading. Check that the repeated entries are actually identical after accounting for spaces, punctuation, and spelling. If you used a formula, verify that the comparison range includes both occurrences and that the formula refers to the correct name column.

Unexpected names are highlighted. Conditional formatting may be applied to a larger or different range than intended. Open Home > Conditional Formatting > Manage Rules and inspect the rule’s Applies to range. Also check whether the rule is comparing the names only or a wider selection containing other text or numbers.

The formula displays as text or does not calculate. Make sure the entry begins with an equals sign and is in a cell formatted as General rather than Text. If the cell is formatted as Text, change the format to General, edit the formula, and press Enter. Check for a leading apostrophe before the equals sign. If Excel uses a different regional list separator on your computer, it may require semicolons instead of commas; the formulas here use the comma syntax specified for standard English Excel settings.

Blank rows seem to be included. If you want to avoid evaluating empty cells, use the formula-based conditional-formatting rule that checks A2 is not blank. For a helper column, you can also leave blank source cells blank. With names in A2:A100 and a helper formula in B2, enter =IF(A2="","",COUNTIF($A$2:$A$100,A2)>1) and fill down. This returns an empty string for a blank source cell and TRUE or FALSE for a name.

New entries are not being checked. Your formula range or conditional-formatting Applies to range may end before the new rows. Extend both ranges to include the added names, or use a Table and verify that its formula and formatting extend as expected.

Frequently Asked Questions

Does Excel have a built-in way to find duplicate names?
Yes. Select the name cells and use Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. Choose a format and select OK. This is the fastest way to see repeated values without creating a helper column.

How do I find duplicate names but keep the original list?
Use Conditional Formatting or add a COUNTIF formula in a separate column. Both methods identify matching entries without deleting or changing the source names. Filter the formula results if you want to review only the matches.

Can Excel highlight only the second and later occurrence?
Yes. Use the expanding COUNTIF formula shown above, =COUNTIF($A$2:A2,A2)>1, in a helper column and fill it down. TRUE marks later occurrences, while the first occurrence stays FALSE.

Does Excel treat uppercase and lowercase names as different?
No. COUNTIF and the Duplicate Values conditional-formatting rule are not case-sensitive for this comparison. “JAMIE PARK” and “Jamie Park” are treated as matching text. They may still differ because of spaces or punctuation.

How can I find names that are almost the same but not exact matches?
First standardize common differences such as extra spaces, punctuation, and name order. Excel’s duplicate rule finds matching values; it does not decide whether misspellings or nicknames refer to the same person. For uncertain matches, compare additional identifying details and review the candidates manually.

Can I remove the duplicates after finding them?
You can use Data > Remove Duplicates, but that changes the data and may remove records you need. Make a copy first, select the correct columns, and confirm how Excel should identify a duplicate row. If you only want to find repeats, use highlights or a formula and leave the source list unchanged.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.