This reference vlog demonstrates how to search for duplicate and unique values, and identify them by highlighting them. We can apply filter after that base on cell color, and you have all the duplicate and unique cells you need.