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
Just to clarify, I had to specify only the left column as the data range for this to work since I had no true duplicates when all fields were considered.