以下是引用君柳在2007-9-5 18:59:05的发言:
=INDEX(Sheet1!$B$1:$B$4,SMALL(IF(Sheet1!$A$1=1,ROW($A$1:$A$4)),ROW(1:1))) =INDEX(Sheet1!$B$1:$B$4,SMALL(IF(Sheet1!$A$1=1,ROW($A$1:$A$4)),ROW(2:2))) =INDEX(Sheet1!$B$1:$B$4,SMALL(IF(Sheet1!$A$1=1,ROW($A$1:$A$4)),ROW(3:3))) =INDEX(Sheet1!$B$1:$B$4,SMALL(IF(Sheet1!$A$1=1,ROW($A$1:$A$4)),ROW(4:4))) ,,先收下....有用的好招~ |