This type of question comes up a lot. Are you joining data sources together? If so, data blending may be a better option.
See if this helps at all--it briefly discusses the data blending option:
I am also attaching a very simple example workbook that demonstrates a case where data blending removes duplicates.