Remove Duplicates

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!





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