This is sample data to check duplicate complaint. we have trace duplicated complaint with “Product Serial No.” and if complaint is “Open” then our formula will show that “Complaint is duplicate” other wise the formula will show blank, check out the video below and download the sample file from download button as given here under.
Formula applied in Column i =IF(COUNTIF($F$2:$F$27,F4)>1,”Duplicate”,””)
Formula applied in Column J =IF(AND(H4=”Open”,I4=”Duplicate”),”Repeated Complaint”,””)
Formula in Conditional Formatting =$J2=”Repeated Complaint”
Output
Download Practice File (Excel Format)
Video Tutorial
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
