[公式题目]产品名称下面插个空

JLxiangwei

1. =INDEX(A:A,RIGHT(SMALL(--TEXT(COLUMN(2:2)-B$2:B$9,"99;"&ROW($2:$9)&";"&ROW($2:$9)+99%),ROW(A1)),2))&""

复制代码

数组下拉

1. =INDEX(A:A,RIGHT(SMALL(TEXT(COLUMN(2:2)-B$2:B$9,"99;!0;!1")*99%+ROW($2:$9),ROW(A2)),2))&""

复制代码

数组下拉

1. =INDEX(A:A,RIGHT(SMALL(TEXT(COLUMN(1:1)-B2:B9,"99;!0;99%")+ROW(2:9),ROW(1:99)),2))&""

复制代码

区域数组

1. =CHAR(64+RIGHT(SMALL(TEXT(COLUMN(1:1)-B2:B9,"99;!0;64%")+ROW(1:8),ROW(1:99)),2))

复制代码

取巧一下，刚刚80个

xwscs

=T(OFFSET(A1,RIGHT(SMALL((MID(REPT(ROW(1:8),B2:B9)&9,COLUMN(A1:AD1),2)&0&0)%,ROW(141:240))),))多单元格引用

=OFFSET(A$1,RIGHT(SMALL(--(0&MID(REPT(ROW($1:$8),B$2:B$9)&9,COLUMN(A:AD),2)),ROW(A1)+140)),)&"" 下拉
=T(OFFSET(A1,RIGHT(LARGE(-(0&MID(REPT(ROW(1:8),B2:B9)&9,COLUMN(A:AD),2)),ROW(141:240))),))

xiaofx11

先东拼西凑一个

1. =IF(OR(MMULT(N(ROW($1:$8)>COLUMN(A:H)),$B$2:$B$9)=ROW()-1),"",LOOKUP(ROW()-1,MMULT(N(ROW($1:$8)>COLUMN(A:H)),$B$2:$B$9),$A$2:$A$9))

复制代码

chen_pinghui

1. =INDIRECT(TEXT(SMALL(IF(COLUMN(A:AD)>B$2:B$9,4^5,ROW($2:$9))/1%+3-(COLUMN(A:AD)<B$2:B$9)*2,ROW()-1),"r0c00"),)&""

复制代码

技术0分参与下，还是才学会的。{:soso_e127:}

shgey

水平有限，勉强138字符

dongqing1998

F2单元格公式(数组公式下拉):
=IF(ROW(A1)=SUM(INDIRECT("b1:b"&SUM(N(F$1:F1=""))+2)),"",INDIRECT("A"&SUM(N(F$1:F1=""))+2))
=IF(ROW(A1)=SUM(INDIRECT("b1:b"&SUM(N(F$1:F1=""))+2)),"",INDEX(A:A,SUM(N(F$1:F1=""))+2))
=IF(ROW(A1)=SUM(OFFSET(B$1,,,SUM(N(F$1:F1=""))+2)),"",INDEX(A:A,SUM(N(F$1:F1=""))+2))

623697442

学习一下
=IF(COUNTIF($F$1:F1,F1)=SUMIF($A$2:$A$9,F1,$B$2:$B$9)-1," ",LOOKUP(ROW()-1,MMULT(N(ROW($1:$8)>COLUMN(A:H)),B$2:B$9),A$2:A$9))

BLWBBS-仔仔

=IF(OR({6;16;34;46;76;84;95;100}=ROW(A1)),"",LOOKUP(ROW(A1),{0;6;16;34;46;76;84;95;100},A$2:A$9))
我只能做到这样子，计98字符的数组公式，差距大啊

一嘟噜钥匙

1. =IF(OR(ROW(A1)=SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$9)))),"",INDEX(A:A,1+MATCH(ROW(A1),SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$9))))))&""

复制代码

listyun

1. =IF(OR(ROW(A1)=MMULT(N(COLUMN(A:H)<ROW($1:$8)),B$2:B$9),ROW(A1)>=SUM(B:B)),"",LOOKUP(SUM(ROW(A1)-1),MMULT(N(COLUMN(A:H)<ROW($1:$8)),B$2:B$9),A$2:A$9))

复制代码

公式超字节了，先发出来。