HI, new here. I need help in deleting duplicate cells that have same name or account # then based on an action that states "report" even if the others don't I need them deleted:
so I need jon doe to be deleted not only from the line that says report, but also the other 2 entries with his name.
I am stumped
thank you
Name | Acct # | action |
jon Doe | 123456789 | report |
Mary Smith | 12345 | call |
jane grant | 987654 | wait |
jon Doe | 123456789 | |
jon Doe | 123456789 | call |
so I need jon doe to be deleted not only from the line that says report, but also the other 2 entries with his name.
I am stumped
thank you