Bug on dynamic array Filter ?

[hnd12000]

I have this table where I'm trying to filter all non closed projects numbers.
So, I use a filter keeping only the "Current status" I want:

Active

Clarification

On Hold

To initiate

Closing

Despite this, there is still 1 CLOSED that appears

I tried another way having a filter returning all "Current status" except "CLOSED" and yet the same project appears despite being obviously CLOSED.
The data comes from a CSV file generated by another system, so I'm fairly confident that there are no typos in Current status

bug on filter.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Number	Current Status		PEP1010547R	CLOSED		CLOSED	PEP1010547R		PEP0037780R	Rejected		Rejected
2	PEP0037780R	Rejected		PEP0633992R	Active		Active			PEP1010547R	CLOSED		CLOSED	PEP1010547R
3	PEP1010547R	CLOSED		PEP1019941R	Active		0			PEP1032806R	Rejected		Closing PCM
4	PEP1010547R	Closing		PEP1008157R	Active					PEP1020787R	Closing PCM		Active
5	PEP0653514R	CLOSED		PEP1002444R	Active					PEP0633992R	Active		CLOSED in PCE
6	PEP0654553R	CLOSED		PEP1007660R	Active					PEP1019941R	Active		0
7	PEP1008761R	CLOSED		PEP1007781R	Active					PEP1008157R	Active
8	PEP1032806R	Rejected		PEP1036288R	Active					PEP1002444R	Active
9	PEP1020787R	Closing PCM		PEP0655221R	Active					PEP1007660R	Active
10	PEP0633992R	Active								PEP1007781R	Active
11	PEP1019941R	Active								PEP1034407R	Closing PCM
12	PEP1008157R	Active								PEP1036288R	Active
13	PEP1002444R	Active								PEP0344216R	CLOSED in PCE
14	PEP1007660R	Active								PEP0655221R	Active
15	PEP1007781R	Active
16	PEP0408504R	CLOSED
17	PEP1034407R	Closing PCM
18	PEP1036288R	Active
19	PEP0344216R	CLOSED in PCE
20	PEP0658133R	CLOSED
21	PEP0655221R	Active
22	PEP0653133R	CLOSED
Database Table

Cell Formulas
Range	Formula
D1:D9	D1	=FILTER(Database[Number],(Database[Current Status]="Active")+(Database[Current Status]="Clarification")+(Database[Current Status]="On Hold")+(Database[Current Status]="To intiate")+(Database[Current Status]="Closing"))
G1:G3,M1:M6	G1	=UNIQUE(E:E)
H1,N2	H1	=FILTER(D:D,E:E=G1)
J1:J14	J1	=FILTER(Database[Number],(Database[Current Status]<>"CLOSED"))
E1:E9,K1:K14	E1	=XLOOKUP(D1,Database[Number],Database[Current Status])
Dynamic array formulas.

it works for other "CLOSED" (the original database has more than 2500 data), all return correctly except for PEP1010547R

 

[hnd12000]

Ok I realized the issue came from a duplicate

 

[Alex Blakenburg]

You issue is not with the filter function except but with your XLookup in the next column.
The filter function is returning the "Closing" line for "PEP1010547R" but the XLookup is returning the status of the 1st occurence of "PEP1010547R" which says closed.

Why don't you just get the filter function to return both columns in one go ?

=FILTER(Database,(Database[Current Status]="Active")+(Database[Current Status]="Clarification")+(Database[Current Status]="On Hold")+(Database[Current Status]="To intiate")+(Database[Current Status]="Closing"))