Excel

One Way to do this is to use the UNIQUE funciton, which is what I often use. For example, I have several vendor codes for different invoice number. Use the Unique function and it will remove all duplicates and give you only the unique vendor codes. This is helpful when I do entry in the accounting software, especially when there is over 500+ lines of vendor codes. Alternatively, you can use ALT + A + M to remove duplicates, so definitely will start using that more!

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.