Duplicate values aren't wrong, but you might not want to display them. Use this simple technique to hide duplicate values in Excel. Duplicate values aren’t wrong or bad, but they can be distracting.

Hide everything but the working area in an Excel worksheet Your email has been sent If you’ve ever opened a Microsoft Excel workbook to find no columns, rows and/or scrollbars, this is probably why: ...