row()-1 =IF(ROW()>SUM(IF($B$2:$B$10=$E$2,1,0))+1,"",INDEX($C$2:$C$10,SMALL(IF($B$2:$B$10=$E$2,ROW($B$2:$B$10)-1,65535),ROW(A2))))IF($B$2:$B$10=$E$2,1,0))+1,"",还有这个:IF($B$2:$B$10=$E$2,ROW($B$2:$B$10)-1,65535),ROW($B$2:$B$10)-1是什么意思
来源:学生作业帮助网 编辑:作业帮 时间:2024/10/08 18:05:03
x)+/5Ttд rTTk3H3PN6M b@{tLMM5F@ߪg