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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback