Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
I am using a TextJoin formula to combine all values in a range. Is it possible to combine only unique values? I don't want to show any duplicates.
Currently, I'm using the below manual steps and it's a pain. The cells I am combining are names (no numbers).
Step 1= TextJoin
Step 2: Copy/paste the TextJoin information to a new sheet to break formulas
Step 3= Use Text to Column > Delimited > CTRL+J to put each name on a new row
Step 4= Remove duplicates
Note: I prefer to use a formula rather than VBA
Currently, I'm using the below manual steps and it's a pain. The cells I am combining are names (no numbers).
Step 1= TextJoin
Code:
=TEXTJOIN(CHAR(10),TRUE,'Invite List'!G2:X19)
Step 2: Copy/paste the TextJoin information to a new sheet to break formulas
Step 3= Use Text to Column > Delimited > CTRL+J to put each name on a new row
Step 4= Remove duplicates
Note: I prefer to use a formula rather than VBA