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”

Output

Customer Care Complaint Management Excel

 

Download Practice File (Excel Format)

✪ DOWNLOAD FILE 

Video Tutorial

 

Join Our Telegram Group techguruplus telegram group
Join Our Whatsapp Group techguruplus whatsapp group

Group 1  |   Group 2

 

Leave a Comment