Combine Range without duplicates

Nanogirl21

Active Member
Joined
Nov 19, 2013
Messages
277
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
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
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,318
Office Version
  1. 365
Platform
  1. Windows
Dou have the function UNIQUE available in your version of Excel?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,296
Messages
5,571,396
Members
412,386
Latest member
Yasaman
Top