excel函数吧 关注:9,146贴子:14,979
  • 1回复贴,共1

怎样把一列中不同类型的数据个数,统计在一个单元格里

只看楼主收藏回复



IP属地:广东1楼2018-01-19 20:26回复
    =IF(COUNT(IF(FIND("A",A1:A100,1)>1,"",1))<>0,COUNT(IF(FIND("A",A1:A100,1)>1,"",1)),"")&"A"&IF(COUNT(IF(FIND("T",A1:A100,1)>1,"",1))<>0,COUNT(IF(FIND("T",A1:A100,1)>1,"",1)),"")&"T"&IF(COUNT(IF(FIND("M",A1:A100,1)>1,"",1))<>0,COUNT(IF(FIND("M",A1:A100,1)>1,"",1)),"")&"高"
    公式复制过去粘贴,三键回车以数组方式运算,Ctrl+Shift+Enter三键同时按下


    IP属地:陕西2楼2018-01-22 14:31
    回复