A列部门为“采购部”的数量
=COUNTIF(A:A,“采购部”)
02
A列非空单元格的个数
=COUNTIF(A1:A10,“<>”)
03
A列单元格包含“采购部”的数量
=COUNTIF(A:A,“*采购部*”)
04
A列单元格中5个字符的数量
=COUNTIF(A:A,"?????")
05
包含文本内容的单元格数量
=COUNTIF(A:A,"*")
06
按分隔符拆分值
例:A1=1:2:3
=TRIM(MID(SUBSTITUTE(A1,":",REPT(" ",100)),1,100)) 值为1
=TRIM(MID(SUBSTITUTE(A1,":",REPT(" ",100)),100,100)) 值为2
=TRIM(MID(SUBSTITUTE(A1,":",REPT(" ",100)),200,100)) 值为3
07
从单元格引用工作表名称
INDIRECT(A2&"!A:B")
08
调起打印机
ActiveSheet.PageSetup.PrintArea = "$A$1:$M$" & j
ActiveWindow.SelectedSheets.PrintOut Copies:=1
联系客服