详细问题描述及疑问:期待您的答案,希望你能感受到,我最真诚的谢意 !
间隔数是什么意思,追问后再调K3=IF(IF(MOD($J3,2)=1,$K$1,$L$1)=K$1,IF(MOD($J3,2)=1,$K$1,$L$1),"")
K2单元格输入下面数组公式后快速向下填充。=IF(ISODD(J2),J2&"是奇数,"&IF(SUM((MOD(J$2:J2,2)=0)*1)=0,"","与上杀乱安消笑那钢愿殖放错一个偶数"&INDIRECT("J"&MAX(IF(MOD(J$2:J2,2)=0,ROW(J$2:J2))))&"间隔是"&ROW()-MAX(IF(MOD(J$2:J2,2)=转热分血0,ROW(J$2:J2)))-1&"")&IF(OR(SUM((MOD(J3:J$16,2)=0)*1)=0,ROW()=COUNTA(J:J)),"","与下一个偶数"&INDIRECT("J"&MIN(IF(MOD(J3:J$16,2)=0,ROW(J3:J$16))))&"间隔是"&MIN(IF(MOD(J3:J$16,2)=0,ROW(J3:J$来自16)))-ROW()-1),"")L2单元格输入下面数组公式后快速向下填充。=IF(ISEVEN问答(J2),J2&"是偶数,"&IF(SUM(MOD(J$2:J2,2)*1)=0,"","与上一个奇数"&INDIRECT("J"&MAX(IF(MOD(J$2:J2,2),ROW(J$2:J2))))&"间隔是"&ROW()-MAX(IF(MOD(J$2:J2,2),ROW(J$2:体易我玉什断封或皮都季J2)))-1&"")&IF(SUM(MOD(J3:J$16,2)*1)=0,"","与下一个奇数"&INDIRECT("J"&MIN(IF(MOD(J3:J$16,2),ROW(J3:J$16))))&"间隔是"&MIN(IF(MOD(J3:J$16,2),ROW(J3:J$16)))-又沿ROW()-1),"")