...一个EXCEL的表格按另外一个表格顺序来排列 sheet1中排序是固定的,sh...答:=IFERROR(INDEX(A:A,INDEX(MATCH(Sheet1!$A$2:$A$26,Sheet2!$A$2:$A$25,)+1,SMALL(IF(ISNUMBER(MATCH(Sheet1!$A$2:$A$26,Sheet2!$A$2:$A$25,)),ROW($2:$26)-1,4^8),ROW(1:1))),"")同时
excel中怎么把一列中的数值1-30的值都返回到另一列中为1答:操作说明:先在你原有的资料上(工作表名为Sheet1)增加辅助列(设在E列--H列),在E2单元格输入公式:=IF(AND(C2>0,C2<30),A2&",",""),下拉至资料最后哪行,在G2单元格输入公式:=IF(AND(C2>=30,C2<=60),A2&",",""),下拉至资料最后哪行,再在F2输入公式:=CONCATENATE(E2,E3,E4,E5,...