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.
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)
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)
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.
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.
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.
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.
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.
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.