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

7535668

前表金额根据发票号用SUMIFS合计金额，想根据发票号从回款表中提取同发票号的收款日期在后方显示收款日期并用, 分割展示在一个单元格。求助各位大佬，万分感谢！ 回款信息.rar (13.87 KB, 下载次数: 17)

2024-8-6 12:41 上传

点击文件名下载附件

效果类似：2024-1-31,2024-2-5,2024-3-4

huaichuan1

这样？

1. =TEXTJOIN(",",,TEXT(FILTER(回款!$D$3:$D$43,回款!$B$3:$B$43=C2,""),"yyyy-mm-dd"))

复制代码

博爱风雨同舟

=ARRAYTOTEXT(TEXT(FILTER(回款!$D$3:$D$43,回款!$B$3:$B$43=C2),"e/m/d"))

hugeinfo

=TEXTJOIN(",",,TEXT(FILTER(回款!$D$3:$D$43,回款!$B$3:$B$43=C2),"yyyy-mm-dd"))

7535668

huaichuan1 发表于 2024-8-6 14:58
这样？

感谢老师！

7535668

博爱风雨同舟 发表于 2024-8-6 15:02
=ARRAYTOTEXT(TEXT(FILTER(回款!$D$3:$D$43,回款!$B$3:$B$43=C2),"e/m/d"))

感谢老师！

7535668

hugeinfo 发表于 2024-8-6 15:08
=TEXTJOIN(",",,TEXT(FILTER(回款!$D$3:$D$43,回款!$B$3:$B$43=C2),"yyyy-mm-dd"))

感谢各位老师！感谢各位大佬！膜拜

hxj119

=TEXTJOIN(",",,TEXT(FILTER(回款!$D$3:$D$43,回款!$B$3:$B$43=C2),"e-m-d"))

leepoison

=TEXTJOIN(",",1,TEXT(FILTER(回款!D:D,回款!B:B=C2),"yyyy/m/d"))

7535668

hxj119 发表于 2024-8-6 15:56
=TEXTJOIN(",",,TEXT(FILTER(回款!$D$3:$D$43,回款!$B$3:$B$43=C2),"e-m-d"))

感谢老师！学习了