Find 04)

Find Duplicates, Marks All But the Last Item Found as ‘Duplicate’

This function writes the word “Duplicate” beside a value if the value directly below it is the same.

You must first sort your data off the column being analyzed. You must also insert an empty column immediately to the right of the column being analyzed.

When you expect a lot of duplicate values and you don’t care about which lines you will remove this is the function to use.


Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc