F20:G31{=IFERROR(INDEX(A:A,RIGHT(LARGE(IF(ISERR(FIND($A$21:$A$33,$A$36)),$B$21:$B$33/1%+ROW($21:$33)),$E20),2)),"")
C20{=IF(ISERR(FIND(A20,A$36)),SUM(N(IF(ISERR(FIND(A$21:A$33,A$36)),B$21:B$33/1%+ROW($21:$33),)>B20/1%+ROW()))+1,"")
利用 E F列 F20:G31=IF(ISERR(FIND(A20,A$36)),VLOOKUP(A20,IF({1,0},F$20:F$31,E$20:E$31),2,),"")
留言
張貼留言