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.
About the Rabi Gurung
I am a software developer in Calgary, Alberta, Canada with passion in getting my fingers in any new technology. I have been doing software development when 10 years old and have never looked back. Now with well over 30 years of software development, I wanted to share some of these key knowledge with the people of the world in the wide web.