Avatar of Jeff McClellan
Jeff McClellan
Flag for United States of America

asked on 

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.

= unique email addresses from the array ([@[Advisor_Email]],&"; "&[@[Customer_Email]],&"; "&[@[Consultant1_Email]]&"; "&[@[Consultant2_Email]]...)

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon