Y2- =IF(ROW(A1)>COUNT(1/--(ASC(OFFSET($A$4,,(MATCH($W$2,{"一年级","二年级","三年级"},)-1)*7,500,1))=ASC($W$1&$W$3))),"",INDEX(OFFSET($A$4,,(MATCH($W$2,{"一年级","二年级","三年级"},)-1)*7,500,6),SMALL(IF(ASC(OFFSET($A$4,,(MATCH($W$2,{"一年级","二年级","三年级"},)-1)*7,500,1))=ASC($W$1&$W$3),ROW(1:500)),ROW(A1)),COLUMN(A1)))
复制代码 三键结束,横拉下拉 |