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