|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
F11
{=INDEX(A:A,SMALL(IF(($B$2:$B$17="合计")*($C$2:$C$17>0),ROW($2:$17),4^8),ROW(1:1)))&""}
G11
{=INDEX(D:D,SMALL(IF(($B$2:$B$17="合计")*($C$2:$C$17>0),ROW($2:$17),4^8),ROW(1:1)))&""}
F30
{=INDEX(A:A,SMALL(IF(($C$21:$C$44="合计")*MAX(--SUBSTITUTE(SUBSTITUTE($B$21:$B$44,"年",),"月",))=--SUBSTITUTE(SUBSTITUTE($B$21:$B$44,"年",),"月",),ROW($21:$44),4^8),ROW(1:1)))&""}
G30
{=INDEX(D:D,SMALL(IF(($C$21:$C$44="合计")*MAX(--SUBSTITUTE(SUBSTITUTE($B$21:$B$44,"年",),"月",))=--SUBSTITUTE(SUBSTITUTE($B$21:$B$44,"年",),"月",),ROW($21:$44),4^8),ROW(1:1)))&""} |
|