Hi,
I am trying to check the verification effectiveness. To do that I need to do the following:
1. Check if "Nature of Complaint", "Category" & "Sub Category" are repeated after that row.
2. If yes, compare if the "Date of Complaint" is after the "Verification Date" or not.
3. If the "Date of Complaint" is after the "Verification Date" then it should return the "Complaint No." of the previous complaint in the "Result" column
I have written down the "Example Result" for understanding.
Please help
Bookmarks