L3:N16{=IFERROR(OFFSET($A$1,SMALL(IF(MMULT(N($H$3:$J$16="V"),{1;1;1})>={1,2,3},ROW($2:$15)),ROW(A1)),COLUMN(A1)+(COLUMN(A1)>1)*2),"")
O3:O16{=IFERROR(INDEX($2:$2,RIGHT(SMALL(IF(($B$3:$B$16=$L3)*($H$3:$J$16="V"),ROW($3:$16)/1%+{8,9,10}*10001),COUNTIF($L$3:$L3,$L3)),2)),"")
留言
張貼留言