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
Post a Comment