Instead of removing duplicates, I would like a list of the duplicates Excel would remove. The data is imported from another program, and I would like to clean up the source data, so that over time, there would be no duplicates. Is there way to do this?
Mark