result of filter function (date) to convert to horizontal then change format

[ExcelNewbie2020]

I have this formula to filter the date if it meet the condition (number column=1) =FILTER(FILTER(A2:D11,E2:E11=1),{0,0,1,0})

I would like the result to change the date format ("dd mmm") then make it horizontally arrange as below (should be result).. many thanks in advance

name	Emp.#	Date	Dept.	Number
Name1	1001	11-05-22	A	1		RESULT OF FILTER FORMULA		should be result
Name2	1002	11-06-22	B	2		11-05-22		11 May, 11 Jul, 11 Sept, 11 Nov, 13 Nov
Name3	1003	11-07-22	C	1		11-07-22
Name4	1004	11-08-22	A	2		11-09-22
Name5	1005	11-09-22	B	1		11-11-22
Name6	1006	11-10-22	C	2		13-11-22
Name7	1007	11-11-22	A	1
Name8	1008	11-12-22	B	2
Name9	1009	13-11-22	C	1
Name10	1010	14-11-22	A	2

 

[Skovgaard]

Try below:

=TRANSPOSE(TEXT(FILTER(C2:C11,E2:E11=1),"dd mmm"))

/Skovgaard

 

[ExcelNewbie2020]

Try below:

=TRANSPOSE(TEXT(FILTER(C2:C11,E2:E11=1),"dd mmm"))

/Skovgaard

thank you, but can we put it all in a single cell? split with space and a comma?

 

[Skovgaard]

Try this then:

=TEXTJOIN(", ",TRUE,TRANSPOSE(TEXT(FILTER(C2:C11,E2:E11=1),"dd mmm")))

/Skovgaard

 

[ExcelNewbie2020]

Try this then:

=TEXTJOIN(", ",TRUE,TRANSPOSE(TEXT(FILTER(C2:C11,E2:E11=1),"dd mmm")))

/Skovgaard

that workz.. thank you very much..

 

[Skovgaard]

that workz.. thank you very much..

Super, you're welcome
/Skovgaard

 

[Fluff]

FWIW there is no need to transpose the data you could just use

=TEXTJOIN(", ",,TEXT(FILTER(C2:C11,E2:E11=1),"dd mmm"))