EXCEL函数如果B列不为空值,则A列返回序号(1、2、3、4……),排序后不会...答:C2=IF(ISERROR(SMALL(IF(Sheet1!C$2:C$1000<>"",Sheet1!C$2:C$1000),ROW(C1))),"",SMALL(IF(Sheet1!C$2:C$1000<>"",Sheet1!C$2:C$1000),ROW(C1)))B2=IF(ISERROR(INDEX(Sheet1!B$2:B$1000,MATCH($C2,Sheet1!$C$2:$C$1000,0))),"",INDEX(Sheet1!B$2:B$1000,...