|
本帖最后由 cabcyvr 于 2019-6-29 11:51 编辑
H2=IFERROR(SMALL(IF((ISNUMBER(MATCH("*"&(ROW($1:$10)-1),$B2:$G2&"",)))*((ISNUMBER(MATCH("*"&(ROW($1:$10)-1+3),$B2:$G2&"",)))+(ISNUMBER(MATCH("*"&(ROW($1:$10)-1-3),$B2:$G2&"",)))+(ISNUMBER(MATCH("*"&(ROW($1:$10)-1+7),$B2:$G2&"",)))+(ISNUMBER(MATCH("*"&(ROW($1:$10)-1-7),$B2:$G2&"",)))),ROW($1:$10)-1,"/"),COLUMN(A1)),"") 数组复制到M6
V2=IFERROR(SMALL(IF(((ISNUMBER(MATCH($P2:$U2+3,$P2:$U2,)))+(ISNUMBER(MATCH($P2:$U2-3,$P2:$U2,)))+(ISNUMBER(MATCH($P2:$U2+7,$P2:$U2,)))+(ISNUMBER(MATCH($P2:$U2-7,$P2:$U2,))))*(MATCH($P2:$U2,$P2:$U2,)=COLUMN($P2:$U2)-15),$P2:$U2,"/"),COLUMN(A1)),"") 数组复制到AA6
|
|