0
Column A   Column B  Column C         Column D
a          a         a, a, b, c, c    a, b, c
a          b
b          c
c
c

Can anybody please help me with my problem? I need unique values in one cell. 

B2=INDEX($A$2:$A$6, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$6), 0))

So far I've found how to make list separated with commas.

C2 = {=TEXTJOIN(", ", TRUE, A2:A6)}

How to apply Index or other function to get unique values in D2 ?

Miso Hora
  • 3
  • 1
  • Copy the source and paste in another set of cells, then use the "remove duplicates" button... Or if it has to be a function, check on here - several questions around this. See this for one : https://stackoverflow.com/q/1429899/4961700 – Solar Mike May 29 '19 at 07:01

2 Answers2

1

Would this work in D2:

=TEXTJOIN(", ",TRUE,IF(MATCH(A2:A6,A2:A6,0)=MATCH(ROW(A2:A6),ROW(A2:A6)),A2:A6,""))

Confirm through CtrlShiftEnter

Unable to test this myself, no TEXTJOIN() on my Excel 2016 :(

JvdV
  • 70,606
  • 8
  • 39
  • 70
0

there is problem to use function "textjoin" in Excel 2010 ... hmmm some of my school computers runs only 2010 version. So, I've found this VBA: string concatenation

Miso Hora
  • 3
  • 1