SUMIFS反向查组成日期，且用,分隔显示

7535668

leepoison 发表于 2024-8-6 16:05
=TEXTJOIN(",",1,TEXT(FILTER(回款!D:D,回款!B:B=C2),"yyyy/m/d"))

感谢感谢！谢谢老师们

沈默00

=CONCAT(TEXT(FILTER(回款!$D:$D,回款!$B:$B=$C2),"e/m/d")&"、")  下拉

7535668

沈默00 发表于 2024-8-7 08:18
=CONCAT(TEXT(FILTER(回款!$D:$D,回款!$B:$B=$C2),"e/m/d")&"、")  下拉

好的，感谢，学习了

mjm04

=TEXTJOIN(CHAR(10),,FILTER(TEXT(回款!D3:D1000,"yyyy/m/d"),回款!$B$3:$B$1000&回款!$C$3:$C$1000=$C2&$D2))

函数 返回的是“文本型日期”