|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 我走我流 于 2020-1-9 16:28 编辑
不怕卡的话,把C1:c20000改成C:C
=LOOKUP(1,0/($C$1:$C$20000<>""),ROW($C$1:$C$20000))-LOOKUP(1,0/(E2=$C$1:$C$20000)/($C$1:$C$20000<>""),ROW($C$1:$C$20000))+1
=LOOKUP(1,0/($C$1:$C$20000<>""),ROW($C$1:$C$20000))-LOOKUP(1,0/(E2=$C$1:$C$20000)/($C$1:$C$20000<>""),ROW($C$1:$C$20000))+1
第2问
=COUNT(0/FREQUENCY(INDIRECT("c"&LOOKUP(1,0/($C$1:$C$20000<>""),ROW($C$1:$C$20000))&":c"&LOOKUP(1,0/(E2=$C$1:$C$20000)/($C$1:$C$20000<>""),ROW($C$1:$C$20000))),ROW($1:$10)-1))
|
评分
-
1
查看全部评分
-
|