1-4写在第一行；5-8从第二行开始输入公式。Lookup是普通格式，其他是数组公式
方法1 =INDEX(A:A,SMALL(IF(COLUMN(1:1)<=B$1:B$2,{1;2},4^8),ROW()))&""
方法2 =LOOKUP(,0/FREQUENCY(ROW(),SUMIF(OFFSET(B$1,,,ROW($1:$9)),"<>")),A:A)&""
方法3 =INDEX(A:A,SMALL((B$1:B$2<COLUMN(A:Z))/1%+{1;2},ROW()))&""
方法4 =INDEX(A:A,SMALL(IF(B$1:B$3>=COLUMN(A:K),{1;2}),ROW()))
方法5 =INDEX(A:A,SMALL(IF(B$1:B$2>=COLUMN(A:K),{1;2}),ROW(A1)))
方法6 =OFFSET(A$1,MIN(IF(COUNTIF(c$1:c1,A$1:A$2)<B$1:B$2,{1;2}))-1,)
方法7 =LOOKUP(ROW()-2,IFERROR(SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$4)-1)),),A$1:A$3)&""方法8 =INDEX(A:A,MATCH(ROW()-2,IFERROR(SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$4)-1)),)))&""
方法1 =INDEX(A:A,SMALL(IF(COLUMN(1:1)<=B$1:B$2,{1;2},4^8),ROW()))&""
方法2 =LOOKUP(,0/FREQUENCY(ROW(),SUMIF(OFFSET(B$1,,,ROW($1:$9)),"<>")),A:A)&""
方法3 =INDEX(A:A,SMALL((B$1:B$2<COLUMN(A:Z))/1%+{1;2},ROW()))&""
方法4 =INDEX(A:A,SMALL(IF(B$1:B$3>=COLUMN(A:K),{1;2}),ROW()))
方法5 =INDEX(A:A,SMALL(IF(B$1:B$2>=COLUMN(A:K),{1;2}),ROW(A1)))
方法6 =OFFSET(A$1,MIN(IF(COUNTIF(c$1:c1,A$1:A$2)<B$1:B$2,{1;2}))-1,)
方法7 =LOOKUP(ROW()-2,IFERROR(SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$4)-1)),),A$1:A$3)&""方法8 =INDEX(A:A,MATCH(ROW()-2,IFERROR(SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$4)-1)),)))&""
