如图C2=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF($C$1:C1,$A$2:$B$7)=0)*($A$2:$B$7<>""),ROW($A$2:$B$7)*100+COLUMN($A$2:$B$7),"")),"R0C00"),),""),按CTRL+SHIFT+ENTER结束公式.