F2==IFERROR(INDEX($A$1:$A$7,SMALL(IF(MATCH($A$2:$A$7,$A$2:$A$7,0)=ROW($A$2:$A$7)-1,ROW($A$2:$A$7),4^8),ROW()-1),),"")
G2==IFERROR(INDEX($B$1:$B$7,SMALL(IF($A$2:$A$7=$F2,ROW($B$2:$B$7),4^8),COLUMN()-6),),"")
都是数组公式,按CTRL+SHIFT+回车结束,如果是03版本的,把IFERROR改成if(iserror(),"",)
温馨提示:答案为网友推荐,仅供参考