Uploaded August 2026 | Updated September 2026, 11 hours ago
Got lists spread across multiple columns? Here's the formula that flattens them into one clean, sorted, duplicate-free list, and updates itself when you add new names.
=SORT(UNIQUE(TOCOL(range,1)))
- TOCOL flattens your columns into a single column
- The "1" ignores blanks so you don't get gaps
- UNIQUE removes duplicates
- SORT puts everything in order
- Extend your range so new entries show up automatically
No copy-paste. No manual updates. One formula that stays live as your data changes.
Works in Excel 365 and Excel 2021+.
500,000+ people have taken our courses so far. If you want to go deeper: 👉 link.xelplus.com/yt-d-all-courses
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
🔓 Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
📲 Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/in/leilagharani
#Excel
Got lists spread across multiple columns? Here's the formula that flattens them into one clean, sorted, duplicate-free list, and updates itself when you add new names.
=SORT(UNIQUE(TOCOL(range,1)))
- TOCOL flattens your columns into a single column
- The "1" ignores blanks so you don't get gaps
- UNIQUE removes duplicates
- SORT puts everything in order
- Extend your range so new entries show up automatically
No copy-paste. No manual updates. One formula that stays live as your data changes.
Works in Excel 365 and Excel 2021+.
500,000+ people have taken our courses so far. If you want to go deeper: 👉 link.xelplus.com/yt-d-all-courses
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
🔓 Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
📲 Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/in/leilagharani
#Excel
