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.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback