Remove duplicate values & keep row sequence with blanks

[Mooncake1]

hi friends!

i'm using filter formula to build my list in column A. I have example of the formula in column D.

what i am attempting to do is create a column like C where the duplicates are removed, only leaving the first occurring number.

ideally I would like to wrap this formula around the filter formula that is in column D so it doesn't take up two column (maybe do i use =LET?)

here is the sheet!

Book1.xlsx
	A	B	C	D	E	F
1	Number list		Unique in row order	Example FILTER	YES	<- Key word
2	435		435	435		YES
3	34		34	34		YES
4	4365		4365	4365		YES
5	568		568	568		YES
6						YES
7	43		43	43		YES
8	34			34		YES
9	547		547	547		YES
10	768		768	768		YES
11						YES
12						YES
13	34			34		YES
14	54356		54356	54356		YES
15	56		56	56		YES
16	7		7	7		YES
17	76		76	76		YES
18	65		65	65		YES
19	54		54	54		YES
20	65478		65478	65478		YES
21	769578		769578	769578		YES
22	53		53	53		YES
23						YES
24						YES
25						YES
26						YES
27	5454		5454	5454		YES
28	54			54		YES
29						YES
30						YES
31	45		45	45		YES
32	54			54		YES
33	54			54		YES
34						YES
35	24		24	24		YES
36	576		576	576		YES
37	34			34		YES
38	7			7		YES
39	7			7		YES
Sheet1

Cell Formulas
Range	Formula
D2:D39	D2	=IFERROR(IF(FILTER(A1:A100,ISNUMBER(MATCH(F1:F100,E1,0)))=0,"",FILTER(A1:A100,ISNUMBER(MATCH(F1:F100,E1,0)))),"")
Dynamic array formulas.

thanks any help is appreciative ! :D

 

[Peter_SSs]

Is this what you want?

21 09 21.xlsm
	A	B	C
1	Number list		Unique in row order
2	435		435
3	34		34
4	4365		4365
5	568		568
6
7	43		43
8	34
9	547		547
10	768		768
11
12
13	34
14	54356		54356
15	56		56
16	7		7
17	76		76
18	65		65
19	54		54
20	65478		65478
21	769578		769578
22	53		53
23
24
25
26
27	5454		5454
28	54
29
30
31	45		45
32	54
33	54
34
35	24		24
36	576		576
37	34
38	7
39	7
Uniques

Cell Formulas
Range	Formula
C2:C39	C2	=IFNA(IF(MATCH(A2:A39,A2:A39,0)=SEQUENCE(ROWS(A2:A39)),A2:A39,""),"")
Dynamic array formulas.

 

[Mooncake1]

Is this what you want?

21 09 21.xlsm
	A	B	C
1	Number list		Unique in row order
2	435		435
3	34		34
4	4365		4365
5	568		568
6
7	43		43
8	34
9	547		547
10	768		768
11
12
13	34
14	54356		54356
15	56		56
16	7		7
17	76		76
18	65		65
19	54		54
20	65478		65478
21	769578		769578
22	53		53
23
24
25
26
27	5454		5454
28	54
29
30
31	45		45
32	54
33	54
34
35	24		24
36	576		576
37	34
38	7
39	7
Uniques

Cell Formulas
Range	Formula
C2:C39	C2	=IFNA(IF(MATCH(A2:A39,A2:A39,0)=SEQUENCE(ROWS(A2:A39)),A2:A39,""),"")
Dynamic array formulas.

this is exactly what i was trying to do, thank u

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

 

[Mooncake1]

hi here is the full formula in case anyone needs

=LET(Fr,IFERROR(FILTER(A1:A100,ISNUMBER(MATCH(F1:F100,E1,0))),""),IFNA(IF(MATCH(Fr,Fr,0)=SEQUENCE(ROWS(Fr)),Fr,""),""))

 

[Peter_SSs]

What is the significance of cell E1 and column F where every cell appears to contain "YES"?

What does that formula do that my simpler one doesn't?

 

[Mooncake1]

What is the significance of cell E1 and column F where every cell appears to contain "YES"?

What does that formula do that my simpler one doesn't?

Sorry, the "YES" is a filterand only exist when theres data in col D, i just messed up my page a bit sorry