I have a list of unique names. If the first name is present with BOTH "Smith" and "Jones", I want only First Name & "Smith", otherwise don't change. In the below this would be true for John.
Is there an "=Unique(..... " solution for this?
Example Starting List:
Desired Outcome:
Is there an "=Unique(..... " solution for this?
Example Starting List:
First Name | Last Name |
John | Smith |
Mike | Jones |
John | Jones |
Bill | Short |
Jane | Jones |
Bill | Smith |
Desired Outcome:
First Name | Last Name |
John | Smith |
Mike | Jones |
Bill | Short |
Jane | Jones |
Bill | Smith |