WPS excel中不连续的自然数,找出缺少的?答:如图所示 C2=IF(SUMIF(A:A,ROW()-1)=0,"",SUMIF(A:A,ROW()-1))D2=IF(C2="","",VLOOKUP(C2,A:B,2,0))
求助:excle数据处理中有数据缺失,求补数据的代码答:如图:B1=IF(A1<>"",A1,IF(INDEX(ROW(A1:A10),MATCH(1=1,A1:A10<>"",0))-LOOKUP(1,0/($A$1:A1<>""),ROW($A$1:A1))>4,"",AVERAGE(LOOKUP(1,0/($A$1:A1<>""),$A$1:A1),INDEX(A1:A10,MATCH(1=1,A1:A10<>"",0)))数组公式 ...