多条件去重取值 (9539)

G4:J7{=INDEX($C:$C,MIN(IF(($A$3:$A$99=$G$2)*($B$3:$B$99=G$3)*(COUNTIF(G$3:G3,$C$3:$C$99)=0),ROW($3:$99),4^8)))&""

另解=IFERROR(LOOKUP(1,0/($A$3:$A$15=$G$2)/($B$3:$B$15=G$3)/(COUNTIF(G$3:G3,$C$3:$C$15)=0),$C$3:$C$15),"")