=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是什么意思呢!
楼下有截图 ,望大神不吝相指点,谢谢了!