I am having a problem getting the results I need. I have a dataset that lists files sent, type of communication, status...among other data. I need to get results that show only the records that status = "FAILED", however only if there is no success via type of communication.
Example date:
ID FileName CommType Status
1 file1 email success
2 file1 fax fail
3 file1 email success
4 file2 fax fail
5 file3 email fail
6 file4 fax success
7 file4 email success
8 file2 email fail
Results needed:
Rows 4;5;8 only
Thank you very much for any light you can shed on this.
Jim