Customer Care Complaint Management in Excel

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.

Customer Care Complaint Management in Excel

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”


Customer Care Complaint Management Excel


Download Practice File (Excel Format)


Video Tutorial


Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

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 ( 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.

Leave a Comment