Duplicate entries may be valid -- but when they aren't, they can derail your summaries and totals. Use Excel's Validation feature to reject duplicate entries. Duplicates aren’t always a bad thing — ...