List unique values from 5 cells in every row
How do I Concatenate only the unique text values from 4 non-adjacent cells in every row.
EE_Example.xlsx
| = unique email addresses from the array ([@[Advisor_Email]],&"; "&[@[Customer_Email]],&"; "&[@[Consultant1_Email]]&"; "&[@[Consultant2_Email]]...) |
EE_Example.xlsx
Martin Liss
Please update your workbook manually to show the results that you desire.
ASKER
See the column "Desired_Concat_Email" in the attached file for examples of what should be returned for each record. It should not return any duplicate email addresses.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hoping to do it with a function. Is that possible?
ASKER
If the cells I am Concatenating are not always "Step 2" apart. Can I reference the Column names instead?
Ideally, would reference Advisor_Email Customer_Email Consultant1_Email Consultant2_Email
Ideally, would reference Advisor_Email Customer_Email Consultant1_Email Consultant2_Email
Can I depend on there being a '@' character in every email address and not anywhere else?
ASKER
Yes, I believe so.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.