Concat unique data from column

[punit83]

10K

10K

14K

18K

22K

Hello,
I have data in column A but need formula to concat unique data from column.

eg:-
10K / 14K / 18K / 22K


Thanks in Advance

 

[Kerryx]

=TEXTJOIN(",",TRUE,UNIQUE($A$1:$A$5))

 

[punit83]

=TEXTJOIN(",",TRUE,UNIQUE($A$1:$A$5))

Thank You So Much, worked

 

[Peter_SSs]

Thank You So Much, worked

Does that mean you need to update your account profile? Microsoft's UNIQUE Help does not list Excel 2019 has having that function.