About This Article
This article was generated using an automated workflow powered by generative AI. It verifies Microsoft Excel function specifications and organizes UNIQUE and SORT into a format that can be tested with dummy data.
Verification Status: 📘 Confirmed with official Microsoft specifications, unverified on physical Excel hardware
When creating a master candidate list from duplicate assignees, it is safer to output the results to a separate area using UNIQUE and SORT before performing manual deletions.
Try It First
Enter the following into A2:A7.
東京 大阪 東京 名古屋 大阪 福岡
Enter this into C2.
=SORT(UNIQUE(A2:A7))
Observe how the duplicate-free list spills without breaking the source data.
Try Changing One Item
Add 札幌 to A8 and change the range to A2:A8. Verify that the results automatically expand.
Why It Is Useful
While the "Remove Duplicates" feature alters the source data, UNIQUE generates results in a separate location. By adopting a workflow where you review the output before pasting it as values, you can create master candidates while preserving the original data.
For Real-World Data Containing Blank Cells
Practical spreadsheets often contain blank cells in between. If you want to exclude blanks from your candidates, add FILTER as a secondary step after verifying how it works.
=SORT(UNIQUE(FILTER(A2:A100,A2:A100<>"")))
Instead of nesting functions all at once from the beginning, checking the role of UNIQUE → SORT → FILTER step by step makes it easier to troubleshoot formulas.
For Professional Use
This can also be used to check for inconsistent naming in department names, client names, application categories, and more. However, extra spaces such as 東京 and 東京 may be treated as distinct values. When normalizing with functions like TRIM, use helper columns to review the data rather than overwriting the source columns directly.
In the Daily-Code-Samples version, sample data, basic formulas, blank exclusion, Excel table integration, and candidate count verification are all combined into a single learning module. On the blog, you can understand the minimal behavior, and on GitHub, you can gradually build up your formulas for real-world tasks.
Conclusion
UNIQUE + SORT is not just a time-saving function; it can be used as a tool to preserve original data while observing differences. Start by viewing the results in a dummy column and checking how the output changes when you add a single entry.
Official Documentation
Microsoft Support: UNIQUE function
Microsoft Support: SORT function
Microsoft Support: FILTER function
