[已解决]函数公式求助

sixnu

蝶·舞 发表于 2014-8-12 15:17
改用TEXT也可以

这个公式应该是有问题的吧？

sixnu

蝶·舞 发表于 2014-8-12 15:17
改用TEXT也可以

原来将\改为!就行了，

1. =TEXT(COUNTIF(B3:G3,"A"),"0A;;")&TEXT(COUNTIF(B3:G3,"B"),"0!B;;")&TEXT(COUNTIF(B3:G3,"C"),"0C;;")&TEXT(COUNTIF(B3:G3,"D"),"0!D;;")&TEXT(COUNTIF(B3:G3,"E"),"0!E;;")

复制代码

蝶·舞

sixnu 发表于 2014-8-12 16:42
原来将\改为!就行了，

用\好一点，不受软件语言版本的限制

contending

1. =IF(COUNTIF(B3:G3,"A")>0,COUNTIF(B3:G3,"a")&"A","")&IF(COUNTIF(B3:G3,"B")>0,COUNTIF(B3:G3,"B")&"B","")&IF(COUNTIF(B3:G3,"C")>0,COUNTIF(B3:G3,"C")&"C","")&IF(COUNTIF(B3:G3,"D")>0,COUNTIF(B3:G3,"D")&"D","")&IF(COUNTIF(B3:G3,"E")>0,COUNTIF(B3:G3,"E")&"E","")

复制代码