|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
关于合并单元格计数,刚想到了八种方法,欢迎补充
=COUNTA(B2:B20)-SUM(D3:D20)
=ROWS(2:$20)-SUM(E3:E$20)
=SUM(SMALL(IF(A$2:A$20>"",ROW($2:$20),21),COUNTA(A$2:A2)+{0,1})*{-1,1})
=MATCH(1=0,A3:A$21="",-1)
=MATCH(,(A3:A21=0)-(B3:B21=0),)
=ROUND(MODE((A3:B12=0)%+ROW($1:$10)),)
=INDEX(FREQUENCY(-ROW($2:$20),-(A$2:A$20>0)*ROW($2:$20)),ROW()-1)
=MATCH(1,FREQUENCY(1,N(K3:K$20>0)),)
启发源于lichen0407的提问,在此感谢,原贴:https://club.excelhome.net/thread-1613942-1-1.html
|
评分
-
13
查看全部评分
-
|