三列符合條件 提取 (9037)

E2:G10{=IFERROR(INDEX(A:A,RIGHT(SMALL(IF(ISNUMBER(MATCH($A$2:$A$10&-$B$2:$B$10,$A$2:$A$10&$B$2:$B$10,))*ISNA(MATCH($A$2:$A$10&-$B$2:$B$10&$C$2:$C$10,$A$2:$A$10&$B$2:$B$10&$C$2:$C$10,)),MATCH($A$2:$A$10,$A:$A,)/1%+ROW($2:$10)),ROW(A1)),2)),"")