|
B05
1- =SUM(FREQUENCY(A8:A13,C8:C9)*{0;1;0})
复制代码- =INDEX(FREQUENCY(A8:A13,C8:C9),2,1)
复制代码 2- =LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26,),3)
复制代码 3 考虑大小写区别- =COUNT(0/FREQUENCY(IF(A30:C35>9^9,CODE(A30:C35)+10^3,A30:C35),IF(A30:C35>9^9,CODE(A30:C35)+10^3,A30:C35)))
复制代码 不考虑大小写区别- =SUM(--(FREQUENCY(IF(A30:C35>9^9,CODE(LOWER(A30:C35))+10^3,A30:C35),IF(A30:C35>9^9,CODE(LOWER(A30:C35))+10^3,A30:C35))>0))
复制代码 4- =IF(SUM(FREQUENCY(B40,{12,16})*{0;1;1}),"合格","不合格")
复制代码- =IF(INDEX(FREQUENCY(B40,{12,16}),1,1),"不合格","合格")
复制代码 |
评分
-
查看全部评分
|