您好，我想咨询wps中满足同一个条件的多个结果要在同一个单元格中显示

关键字：wps 更新时间：2019-10-13 04:47:57 155次访问

以此图为例，介绍公式法。如果比此图更复杂，用自定义函数法。

=TEXT(G2,"e-m-d")&" "

&TEXT(H2,"e-m-d")&" "

&TEXT(I2,"e-m-d")&" "

&TEXT(J2,"e-m-d")&" "

&TEXT(K2,"e-m-d")

=IF(MAX(COUNTIF($B$2:$B$15,$D$2:$D$6))-COLUMN(A1)+1>0,COLUMN(A1),"")

=IFERROR(INDIRECT("A"&SMALL(IF($B$2:$B$15=$D2,ROW($B$2:$B$15)),COLUMN(A$1))),"")

相关标签：wps