感觉问题复杂,所以求助高手解决Excel2003表格问题,答案满意重谢_百度...答:=IF(B2>10,IF(MAX(INDIRECT("B"&SMALL(IF($B$2:$B$120=10,ROW($A$2:$A$120),""),COUNTIF($B$2:B2,10))):INDIRECT("B"&SMALL(IF($B$2:$B$120=10,ROW($A$2:$A$120),""),COUNTIF($B$2:B2,10)+1)))=B2,B2,""),"")同时按CTRL SHIFT 回车键下拉 ...