excel 时间如何由近到远排序答:=LEFT(B3,FIND("天",B3,1)-1)*24+MID(B3,FIND("天",B3,1)+1,FIND("小",B3,1)-FIND("天",B3,1)-1)
excel序号里面怎么跳4跳7,就是排号码888001-888500中的4跟7都不要_百...答:数组公式,按下SHIFT+CTRL+ENTER三键结束输入,再下拉复制公式 或 =888000+INT(ROW(A1)/8)*10+INDEX({1,2,3,5,6,8,9,0},MOD(ROW(A8),8)+1)下拉复制公式 现在要00801-往后排300个 =TEXT(800+INT(ROW(A1)/8)*10+INDEX({1,2,3,5,6,8,9,0},MOD(ROW(A8),8)+1),"00000")或...