EXCEL在数值表区域获取最后一个大于0的值 采用数组公式: {=OFFSET(A2,0,MAX(IF((A2:J2)>0,COLUMN(A2:J2),0))-COLUMN(A2))} 或加报错判断: {=IFERROR(OFFSET(A2,0,MAX(IF((A2:J2)>0,COLUMN(A2:J2),0))-COLUMN(A2)),0)=IFERROR(OFFSET(A2,0,MAX(IF((A2:J2)>0,COLUMN(A2:J2),0))-COLUMN(A2)),0)}