C2:D10{=INDEX(PERCENTILE(IF("WK"&WEEKNUM(ROW(INDIRECT((YEAR($F$2)&"/1/1")*1&":"&(YEAR($F$2)&"/12/31")*1)),2)=$B2,ROW(INDIRECT((YEAR($F$2)&"/1/1")*1&":"&(YEAR($F$2)&"/12/31")*1))),{0,1}),COLUMN(A1))
另解{=INDEX(PERCENTILE(IF(WEEKNUM(ROW(INDIRECT((YEAR($F$2)&"/1/1")*1&":"&(YEAR($F$2)&"/12/31")*1)),2)--LOOKUP(1,-RIGHT($B2,{1,2}))=0,ROW(INDIRECT((YEAR($F$2)&"/1/1")*1&":"&(YEAR($F$2)&"/12/31")*1))),{0,1}),COLUMN(A1))
留言
張貼留言