发布网友
共1个回答
热心网友
D3
=INDEX(B:B,MATCH((A$3:A$9=A3)*(C$3:C$9=MINIFS(C$3:C$9,A$3:A$9,A3),A$3:A$9&C$3:C$9,))
CTRL+SHIFT+ENTER
下拉填充