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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

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,119,183
Messages
5,576,575
Members
412,735
Latest member
jwoods1204
Top