From as per various ranges return a sorted A to Z Unique distinct list.

[mmr1]

Hi,


Here is required a formula assistance to make a sorted A to Z unique distinct values in Start from column A:12, as based on data values extracted from column A:3 to D:9.

Sample enclosed for your reference.


Thanks for the help,

Book2
	A	B	C	D
3	Cutting	Mockup	cleaning	Filling
4	Filling	Controling	Mockup	Cutting
5	cleaning	Washing	measurement	loading
6	measurement	Spray	lifting	Washing
7	cleaning	loading	Shift	Concrete
8	Washing	lifting	Concrete	Shift
9	Spray	Break	Cutting	Break
10
11	Unique distinict
12
13
14
15
16
17
Sheet1

 

[Fluff]

Do you have the LET function?

 

[mmr1]

No, I don't have.

 

[Fluff]

Ok, how about

+Fluff v2.xlsm
	A	B	C	D
1
2
3	Cutting	Mockup	cleaning	Filling
4	Filling	Controling	Mockup	Cutting
5	cleaning	Washing	measurement	loading
6	measurement	Spray	lifting	Washing
7	cleaning	loading	Shift	Concrete
8	Washing	lifting	Concrete	Shift
9	Spray	Break	Cutting	Break
10
11	Unique distinict
12	Break
13	cleaning
14	Concrete
15	Controling
16	Cutting
17	Filling
18	lifting
19	loading
20	measurement
21	Mockup
22	Shift
23	Spray
24	Washing
25
Main

Cell Formulas
Range	Formula
A12:A24	A12	=SORT(UNIQUE(TRIM(MID(TEXTJOIN(REPT(" ",200),1,IF(A3:D9="","",A3:D9)),SEQUENCE(COUNTA(A3:D9),,1,200),200))))
Dynamic array formulas.

Pinched from here Unique values for an array of n rows and m columns

 

[mmr1]

Many thanks fluff for your provided solution.

 

[Fluff]

Glad to help & thanks for the feedback.