Skip to main content
AmigoFish

The Excel function nobody reaches for... 🤯

From Leila Gharani · · 50 sec

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

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: 👉 https://link.xelplus.com/yt-d-all-courses

📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter

🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

📲 Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani

#Excel

Back to Leila Gharani · Report a problem