How to Use Excel UNIQUE to List Distinct Names

Open your Excel signup sheet (.xlsx) in Cue Office. Use UNIQUE(A2:A7) to list each distinct name once. To list only names that occur exactly once in the source, set the third argument to TRUE. Both lists update when you edit a name in the source range.

How do you list each signup name once?

Create a new workbook in Cue Office and paste the practice data into A1. The six signup records are in A2:A7, and columns D and F already have headers, leaving the rows below empty for formula results.

Column A contains six signup records; columns D and F have only result headers
The original signup list stays in column A, leaving space below the headers in columns D and F for formula results.

Click D2 and paste the formula below. The list spills downward from D2 in the order names first appear. Although Maya and Theo each appear twice, column D retains one instance of each, returning Maya, Theo, Lina, and Omar.

=UNIQUE(A2:A7)
D2 uses the UNIQUE formula, and column D displays Maya, Theo, Lina, and Omar
Maya and Theo each appear twice in the source. Column D lists each name once.

How do you list only names that appear exactly once in the source list?

Click F2 and paste the formula below. The second argument FALSE compares by row, and the third argument TRUE returns only names that occur exactly once in A2:A7. Because Maya and Theo each have two rows in the source list, column F displays only Lina and Omar.

=UNIQUE(A2:A7,FALSE,TRUE)
F2 uses UNIQUE with the third argument TRUE, showing only Lina and Omar in column F
Column F lists only Lina and Omar, who appear exactly once.

Change Maya in A4 to Noah. Column D now lists Maya, Theo, Noah, Lina, and Omar. Because Maya and Noah now each appear only once in the source list, column F updates to Maya, Noah, Lina, and Omar.

A4 changed to Noah; column D shows five names and column F shows Maya, Noah, Lina, and Omar
After the edit to A4, Maya and Noah both appear in column F. Theo still appears twice in the source, so only column D lists Theo.

Change A4 back to Maya, save, and reopen the workbook. Verify that column D returns to four names and column F returns to Lina and Omar.

After restoring A4 to Maya and reopening, column D has four names, column F has two names, and the UNIQUE formula in F2 is visible
After restoring A4 and reopening, column D lists Maya and Theo. Column F leaves them out.

How do you ask Cue AI to generate both dynamic lists at once?

Open a copy of the signup workbook where the result areas in columns D and F are still blank, and click Cue AI. Specify which names each list should retain and where each list should start.

Cue AI button and panel, with the original signup table and blank result columns D and F on the right
After opening Cue AI, confirm there is empty space beneath D2 and F2 for the lists.
Use the signup names in A2:A7 to make two live lists. Starting in D2, show each different name once, retaining the order in which names first appear. Starting in F2, show only names occurring exactly once in the source, in source order. Both lists should update when a source name changes and expand or shrink beneath the existing headers. Edit only D2 and F2 and keep the source names and all headers unchanged.

In this run, Cue AI writes formulas only into D2 and F2. D2 uses UNIQUE. F2 uses COUNTIF to count how many times each name occurs, then uses FILTER to keep names with a count of 1. Save and reopen the copy, inspect the source names and headers, and verify that column D has four names and column F has two names.

AI workbook reopened; the FILTER and COUNTIF formula in F2 is visible, with four names in column D and two names in column F
After reopening, both lists match the manual results. The formula bar shows the actual FILTER and COUNTIF formula in F2.

In the reopened copy, change A4 to Noah. Column D expands to five names, column F expands to four names, and both Maya and Noah enter column F. Theo still appears twice, so Theo stays only in column D.

After reopening the AI workbook and changing A4 to Noah, column D shows five names and column F shows four names
After renaming in the reopened copy, both lists update from the single edit in column A.

Practice with six signup records

Show the full example

Paste the entire block of data into A1. The headers for columns D and F are already in place. Return to formula steps.

Name			Each name once		Appears once only
Maya
Theo
Maya
Lina
Omar
Theo

Check for duplicate signups and name corrections before handoff

When working with your next batch of signups, provide Cue AI with the source name range and starting cells for both lists, asking it to build them using the same criteria. While preparing check-in materials, use the list showing each name once for an initial review. When you spot matching names, check the original roster for registration IDs or contact details to confirm whether it is a duplicate signup or two different attendees sharing a name. When someone corrects their name, update the source record and observe how both lists adjust.

Open the organizer’s PDF signup confirmation (.pdf) for free in Cue Office and check the names against your Excel signup roster (.xlsx). If a name on an ID differs from the signup name, record the original name, corrected name, and who confirmed the change in a Word handoff log (.docx). For a volunteer briefing, use a PowerPoint deck (.pptx) to show which check-in desk handles name corrections. Cue Office offers free spreadsheet, document, and presentation editing.

Download Cue Office for free