Return a duplicate-free list from a range using UNIQUE.
Copy this formula
=UNIQUE(A2:A100)UNIQUE (Excel 365 / 2021) spills the distinct values from a range into a new list automatically. Combine with SORT to get a clean, ordered, de-duplicated list.
=SORT(UNIQUE(A2:A100))→Apple, Banana, Cherry…A sorted, de-duplicated list.
Use Data ▸ Remove Duplicates for a one-off, or Advanced Filter to copy unique values to a new location.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.