Hide Duplicates

The easiest way to hide duplicates.

1. Select the range to hide duplicates

2. On the main menu click Data

3. Click Filter then Advanced Filter

4. Check the box to the left of “Unique Records Only” and hit OK

Sidenote: To unhide them click Data then Filter then Show ALL

Sidenote: This hides based on the left column in your selection

Leave a Comment