✨ Unique List Generator

Goal: Get a list of distinct Departments.
UNIQUE removes duplicates automatically and spills the result.

Result (Spill Range): 0 Found
(Waiting...)
Ready...

💻 Formula Structure

=UNIQUE(array, [by_col], [exactly_once])
  • 1. Array: The range with duplicates (A2:A8).
  • 2. By Col: (Optional) FALSE = Rows (Default).
  • 3. Exactly Once: (Optional) FALSE = Distinct list (Default).
-- Extract unique Dept names
=UNIQUE( A2:A8 )
Status:
-

⚠️ Common Pitfalls

🚫 Dynamic Array Support
UNIQUE is only available in Excel 365, Excel 2021, and newer. Older versions need complex formulas.
🚫 Headers Included
Do not select the header row! Excel will treat "Department" as just another value.
✅ Fix: Start selection from row 2 (A2:A100).