Find 05)

05) Find Duplicates, Marks All as 'Duplicate'

This function writes the word “Duplicate” beside a value if the value directly below it or directly above 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 just a few duplicate values and need to see surrounding data to determine why the lines are different this is the function to use.

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