Find Unique Names in Excel: 3 Reliable Methods

To find a list of distinct names in Excel, enter =UNIQUE(A2:A100) in an empty cell if you use Microsoft 365 or Excel 2021; replace the range with your name cells. For a no-formula option, use Data > Advanced and select Unique records only. These methods return one copy of each name, while Remove Duplicates can delete repeated entries from your original list.

What You’ll Need

A workbook with names arranged in one column, ideally with a header such as Name.
An empty area for the results if you want to preserve the source data. Leave enough room below and, for formula results, to the right for the list to spill.
Microsoft 365 or Excel 2021 for the UNIQUE formula. Advanced Filter and Remove Duplicates are alternatives in desktop Excel if your version does not support UNIQUE.

Before starting, decide what you mean by unique. In this guide, a unique list means a distinct list: each different name appears once, even if it appeared several times in the source. If you instead need names that occur exactly once and must exclude names that repeat, see the FAQ below.

Step-by-Step

Check and identify the source list. Find the column containing the names and note its first and last data cells. For example, if the header is in A1 and the names run from A2 to A100, the data range is A2:A100. Keep the header out of the formula range. If the list has no header, identify the first actual name and use that cell as the start. Avoid selecting whole columns unless necessary, because extra blank cells can make results confusing or slow a large workbook.
Choose a result location. For a formula, click an empty cell outside the source range, such as C2. Make sure the cells below it are clear, because a dynamic array formula places its results in the cells beneath the formula automatically. Do not put the formula inside an Excel Table if you expect it to spill there; place it in a normal range outside the table. For Advanced Filter, pick an empty destination with room for the copied list. If you plan to remove duplicates in place, consider copying the source column to a spare sheet first.
Use UNIQUE for a live distinct list. With names in A2:A100 and the output starting in C2, enter =UNIQUE(A2:A100) in C2 and press Enter. Excel returns one copy of each distinct name, keeping the order in which each name first appeared. For example, if A2:A8 contains Maya, Leo, Maya, Priya, Leo, Chen, Priya, the output is Maya, Leo, Priya, Chen. If names in the source range change, the result updates automatically. The formula requires Microsoft 365 or Excel 2021 or later; Excel for the web also supports it when the workbook has the function available.
Sort the formula results if useful. UNIQUE returns names in first-seen order. To show the distinct names alphabetically instead, use a sorted dynamic array. With names in A2:A100 and the result starting in C2, enter =SORT(UNIQUE(FILTER(A2:A100,A2:A100<>""))) in C2. For the example list above, this returns Chen, Leo, Maya, Priya. FILTER removes truly empty cells before UNIQUE runs, and SORT orders the remaining results. This formula also requires a version with UNIQUE, FILTER, and SORT, such as Microsoft 365 or Excel 2021. Cells containing spaces are not truly empty and will still need cleaning.
Use Advanced Filter if you do not want a formula. Click inside the source list, including its header, then choose Data > Sort & Filter > Advanced. In the Advanced Filter dialog, choose Copy to another location. Check that List range covers the header and all names. Click Copy to and select the top-left cell of the blank destination area. Select Unique records only, then click OK. Excel copies one instance of each distinct record to the destination and leaves the source data unchanged. For a single name column, the copied results will be a distinct name list with its header.
Use Remove Duplicates only when changing the original is acceptable. Select the name column or a copy of it, including its header, and choose Data > Data Tools > Remove Duplicates. Confirm My data has headers if the first selected row is a heading. In the column list, leave the name column selected, then click OK. Excel keeps the first occurrence of each name and removes later matching entries from the selected data. The dialog reports how many duplicate values were removed and how many unique values remain. This action changes the selected range, so make a copy first if you might need the repeated rows later.
Check the output against the source. Confirm the header is present or absent as you intended, and scan the results for blank entries, unexpected spaces, or spelling variants. A distinct list does not decide whether two differently spelled names refer to the same person. For example, Alex Chen and Alex Chen, with an extra space, can remain as separate entries. If an output is missing or looks incomplete, check the range and the formatting or contents of the source cells before repeating the process.
Choose the method that fits how the list will be used. Use UNIQUE when the list should refresh as the source changes. Use Advanced Filter when you need a one-time copy and want to retain the original. Use Remove Duplicates when you deliberately want to reduce the source data itself. If the names are part of records with other columns, do not remove duplicates from the name column alone unless you intend to delete associated information; choose the full table and decide which columns define a duplicate.

Common Mistakes

Including the header in a formula range. If the formula range starts at A1, Excel may treat the heading Name as one of the results. Start at A2 when A1 is a header. Advanced Filter and Remove Duplicates usually need the header included so Excel can identify the list correctly.
Confusing distinct names with names that appear once. UNIQUE returns one copy of a repeated name by default; it does not exclude that name. If Maya appears five times, Maya still appears once in the distinct output. Use the exactly-once option only when the goal is to list names with a count of one.
Expecting the formula to overwrite existing cells. Dynamic array results need an unobstructed spill range. A note, another value, or a merged cell below the formula can block the output. Clear the destination cells or move the formula to an open area.
Removing duplicates from only one column of a multi-column table. If names are linked to phone numbers, departments, or other details, deleting repeated names alone can discard related records. Decide whether duplicate means the same name or an identical whole record, then select the appropriate columns.
Assuming similar-looking text is identical. Extra spaces, nonprinting characters, and spelling differences can make entries that look alike remain separate. Conversely, Excel’s duplicate handling is generally not case-sensitive, so names that differ only in capitalization may be treated as duplicates.

Tips

Keep the original list intact while checking the results. A formula or Advanced Filter is safer for exploration than immediately deleting entries.
Convert the source range to an Excel Table with Insert > Table if it will grow over time. A table makes the source easier to maintain, though a UNIQUE formula placed outside it may need a structured reference or an adjusted range to include newly added names.
Use a clearly labeled destination column, such as Distinct names, so other workbook users know that the output is generated or copied rather than the original data.
If names contain accidental leading or trailing spaces, clean a copy before finding unique values. For example, use Excel’s TRIM function in a helper column, inspect the cleaned names, and then run the distinct-list method on that cleaned column. TRIM removes ordinary extra spaces but does not remove every kind of invisible character.
On Windows, press Enter to confirm a dynamic array formula; no special array-key combination is needed. In Excel for Mac, press Return. Menu names can be arranged slightly differently on Mac, but the desktop Advanced Filter and Remove Duplicates tools are available in Excel for Mac. Excel for the web supports dynamic array formulas, but desktop is the better choice if you cannot find Advanced Filter in the web ribbon.

Troubleshooting

The formula returns #NAME? Your Excel version may not include UNIQUE, or the function name may have been entered incorrectly. Use Microsoft 365 or Excel 2021 or later, or use Advanced Filter as a non-formula alternative.

The formula returns #SPILL!. Select the formula cell and look for the highlighted spill range. Clear any values, merged cells, or other obstructions in that area, then check that the output does not run into the edge of the worksheet.

A blank or zero appears in the results. The selected source range may include blank cells. Use the FILTER version above to exclude truly empty cells, or narrow the range to the populated rows. If a cell looks blank but still appears, click it and inspect the formula bar; it may contain a space or a formula that returns an empty string.

Names that look identical appear twice. Compare the source cells carefully for extra spaces or hidden characters. Clean a copy with a helper column, then generate the distinct list from that column. If you use Advanced Filter, confirm the List range includes the intended column and does not include unrelated fields.

Advanced Filter copies the wrong items or gives an error. Check that the selected List range is contiguous and includes a single, clearly labeled header row. Choose Copy to another location and specify a blank destination. If you selected a multi-column list, Advanced Filter finds unique records across the selected columns, not distinct values in just one of them.

Remove Duplicates deleted data you wanted to keep. Use Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if the action is still available. If the workbook has been saved or other edits have occurred, restore a backup or use version history if available. For future checks, work on a copy or use UNIQUE or Advanced Filter instead.

Frequently Asked Questions

Does UNIQUE change the original names?
No. The formula displays results in a separate spill range and leaves the source cells as they are. Advanced Filter can also copy unique records elsewhere. Remove Duplicates is the method in this guide that changes the selected source range.

How do I find names that appear exactly once?
That is different from creating a distinct list. In UNIQUE, the third argument can be set to TRUE to return only entries that occur exactly once. For names in A2:A100, use =UNIQUE(A2:A100,,TRUE). This syntax requires Excel 2021 or Microsoft 365. If you need a sorted result, you can combine it with SORT, but first confirm that exactly-once results—not one copy of every distinct name—are what you need.

Does Excel treat uppercase and lowercase names as different?
Usually, no. Excel’s standard duplicate-removal tools and UNIQUE treat text comparisons as case-insensitive, so Maya and MAYA are normally considered the same value. If capitalization is meaningful in your data, preserve the source and use a case-sensitive approach rather than relying on the standard duplicate tools.

Can I find unique names in Excel for the web?
Yes. In a supported Microsoft 365 workbook, enter UNIQUE in a blank cell in the browser and the results spill into neighboring cells. The formula updates as its referenced values change. For menu-based filtering, use desktop Excel if the Advanced Filter command is not available in your web interface.

Why does my unique list not update when I add a name?
Check whether the new name is inside the formula’s referenced range. A formula that refers to A2:A100 will not include a name entered in A101. Expand the range, or use a suitable Excel Table reference so new rows are included as the table grows.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.