Create unique sorted list for items in different columns

How to create a unique list from a given list of items?
How to remove duplicates by using Excel function?
How to create a unique sorted list in Excel by using Excel functions?

Interchange row headers and the corresponding contents 👉 https://youtube.com/shorts/4Bk6Pdn_X5Y
Add unique sorted updatable in-cell dropdown with vs without VBA 👉 https://youtu.be/aypLwGoioAk

Excel & VBA discussion public group 👉 https://www.facebook.com/groups/486402069483674
Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗

#Excel #functions

Видео Create unique sorted list for items in different columns канала Ah Sing Excel TV