|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 micch 于 2020-1-21 19:11 编辑
=AGGREGATE(12,6,AGGREGATE(12,6,OFFSET(B1,SMALL((A2:A21="")/1%+ROW(1:20),ROW(1:9)),,FREQUENCY(IF(A2:A21="",ROW(2:21)),IF(A3:A21>0,ROW(3:21)))+1)))
=AGGREGATE(12,6,AGGREGATE(12,6,OFFSET(B1,MODE.MULT(ROW(1:20)-(A2:A21="")),,FREQUENCY(IF(A2:A21="",ROW(2:21)),IF(A3:A21>0,ROW(3:21)))+1)))
=AGGREGATE(12,6,AGGREGATE(12,6,OFFSET(B1,MODE.MULT(ROW(1:20)-(A2:A21="")),,FREQUENCY(ROW(3:22),IF(A3:A21>0,ROW(3:21))))))
我可以瞎猜吗,aggregate我好像用不了
|
|