题一:序列公式: REPT(1,ROW(A1))^2
题二:两个公式:
F22=INDEX(B:B,SMALL(99*(MATCH(B$15:B$24,B$15:B$24,)<A$15:A$24)+ROW($15:$24),ROW(A1)))数组下拉
G22=TEXT(SUM(($B$15:$B$24=$F22)*ISNUMBER(FIND(LEFT(G$21,4),$C$15:$C$24))*IF({1},OFFSET($D$15:$D$24,,-MOD(COLUMN(),2)))),"0;;")数组横拉下拉.
|