晕呀,这题难死了在f3输入:=INDEX(IF(A$1:A$100=LOOKUP(1,0/(E$3:E30),E$3:E3),B$1:B$100,""),SMALL(IF(MATCH(IF(A$1:A$100=LOOKUP(1,0/(E$3:E30),E$3:E3),B$1:B$100,""),IF(A$1:A$100=LOOKUP(1,0/(E$3:E30),E$3:E3),B$1:B$100,""),)=IF(IF(A$1:A$100=LOOKUP(1,0/(E$3:E30),E$3:E3...
|