The best way to do this is by converting your data to an Excel table. Select your data range (A1:E11), press Ctrl + T, and ...
You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback