Combine Range without duplicates

[Nanogirl21]

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

=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

 

[DRSteele]

Dou have the function UNIQUE available in your version of Excel?

 

[Nanogirl21]

Dou have the function UNIQUE available in your version of Excel?

When I types =Unique it did come up. I tried to use it, but I always get error.