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/06/27 16:34:37
![row()-1 =IF(ROW()>SUM(IF($B$2:$B$10=$E$2,1,0))+1,](/uploads/image/z/1244747-11-7.jpg?t=row%28%29-1+%3DIF%28ROW%28%29%3ESUM%28IF%28%24B%242%3A%24B%2410%3D%24E%242%2C1%2C0%29%29%2B1%2C%22%22%2CINDEX%28%24C%242%3A%24C%2410%2CSMALL%28IF%28%24B%242%3A%24B%2410%3D%24E%242%2CROW%28%24B%242%3A%24B%2410%29-1%2C65535%29%2CROW%28A2%29%29%29%29IF%28%24B%242%3A%24B%2410%3D%24E%242%2C1%2C0%29%29%2B1%2C%22%22%2C%E8%BF%98%E6%9C%89%E8%BF%99%E4%B8%AA%3AIF%28%24B%242%3A%24B%2410%3D%24E%242%2CROW%28%24B%242%3A%24B%2410%29-1%2C65535%29%2CROW%28%24B%242%3A%24B%2410%29-1%E6%98%AF%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D)
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是什么意思
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是什么意思呢!
楼下有截图 ,
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是什么意思
row()结果是当前的行号 row($B$2:$B$10)是2-10实数数组 -1的话 就是1-9的数组