Hi Guys,
I have a question regarding an issue, that I cannot seem to find an answer to.
I have 6 columns, where column A got the filenames i need to check, and report the issues on five different columns B:F based on their issues.
Issues count are five and they are as below:
- Ad
- Black Screen
- Floating Ad
- No Ep
- Title Ad
Please find an example of the sheet in the attached, to better understand my question.
The thing is, if an issue was mentioned for any file before, it must be counted once. Like the cell A2 or Show 1, it has the same issue in Column B and Column C, so the issue must be counted once not twice.
Appreciate your fast help.
Thanks.
Bookmarks