回复：函数问题你问我答，太难的不会

=IF(ROW()<14,"aaa/第五盘"&COLUMN(A1)*12-12+ROW(A1)&"芯--"&$F$1&"-"&COLUMN(A1)*12-12+ROW(A1)&"芯--"&404+COLUMN(A1)*12-12-1+ROW(A1),"") 感觉差不多是这样

=IFERROR(IF(VLOOKUP(B2,Sheet1!B:C,2,0)=C2,"",VLOOKUP(B2,Sheet1!B:C,2,0)),"")

这样

=COLUMN(F2)-IFERROR(LOOKUP(1,0/(A2:F2="通过"),COLUMN(A2:F2)),0) 数组3键

=IFERROR(MATCH(FALSE(),OFFSET(A2,,IFERROR(LOOKUP(1,0/(A2:H2="通过"),COLUMN(A2:H2)),0),,COLUMN(H2)-IFERROR(LOOKUP(1,0/(A2:H2="通过"),COLUMN(A2:H2)),0)+1)="不通过",)-1,0)

=SUMPRODUCT((D:D=J2)*(A:A=E:E))

=VLOOKUP(H$2&$G3,IF({1,0},$A:$A&$B:$B,$C:$C),2,0) 数组3键

以前网友分享的照片

=MATCH(1,SIGN(OFFSET(A1,,MATCH(-1,SIGN(A1:H1),)-1,,COLUMNS(A1:H1)-MATCH(-1,SIGN(A1:H1),)+1)),)+MATCH(-1,SIGN(A1:H1),)-1
数组3组

Match的第一参数1改-1 -1改1

=SUMPRODUCT(ISNUMBER(FIND(" "&$K$2:$K$22&" "," "&$A2&" "))*L$2:L$22) 数组3键