E2:H8{=IFERROR(VLOOKUP(COLUMN(A1),OFFSET($B$3,SUM(N($E$1:$H1<>"")),,IFERROR(MATCH(1=1,MATCH(OFFSET($B$3,SUM(N($E$1:$H1<>"")),,4),OFFSET($B$3,SUM(N($E$1:$H1<>"")),,4),)<>{1;2;3;4},)-1,4),2),2,),"")
N2:Q11{=IFERROR(VLOOKUP(COLUMN(A1),OFFSET($K$1,MAX(SMALL(IF($K$2:$K$17>=$K$3:$K$18,ROW($2:$17),99),ROW(A1))),,SUM(SMALL(IF($K$2:$K$17>=$K$3:$K$18,ROW($2:$17),99),ROW(A1)+{0,1})*{-1,1}),2),2,),"")
留言
張貼留言