Do the same with a slight variance
Mattohare uses the same method as I do. However, I use 1 if a dup is found and blank if no dupe. Because in most cases I need to manually delete the duplicates after inspecting the 2 rows of data, I sum the column with the formula in it. This allows me to see how many more I have to go.
Keep Up with TechRepublic