Sort & Unique

SORT & UNIQUE

Usually, I am use to using a pivot table to remove duplicates or use the remove duplicate option. 

An alternative way and more simple way is to use the super helpful function UNIQUE() function & add on the SORT() function to have it in alphabetical order.

Comments

Popular posts from this blog

GETPIVOTDATA

Ranking of UC Schools from Top 110 Ranked National Universities of 2024

Xlookup specific value in the middle of a string