Filter - Hiding duplicates but displaying 1 of the duplicates item

Is it posible when useing filters to hide duplicates but show one of the duplicates? If so how would we do this?

R

CB

Use an advanced filter, and select the "unique records" option and "filter in place"

Thanks Mallycat worked perfectly

@arlu1201, same question but 2 diffrent ways to do it. I will use them both.

R

CB