Scan cell and identify unique values

[sagarrd]

Input:

Column1

A;1;C;A

A;X;Z;3

Output: Unique of Column 1

A

1

C

X

Z

3

 

[CA_Punit]

Try this

Book1
	A	B	C	D
2	A;1;C;A
3	A;X;Z;3
4			A
5			1
6			C
7			X
8			Z
9			3
10
11
Sheet1

Cell Formulas
Range	Formula
C4:C10	C4	=UNIQUE(MID(SUBSTITUTE(TEXTJOIN(";",TRUE,A2:A3),";",""),SEQUENCE(20),1),FALSE,FALSE)
Dynamic array formulas.