|
公式1:- =AND((D2+6)/2*(6-D2+1)=SUM(OFFSET(D2,0,0,6-D2+1)),(D2+1)/2*D2=SUM(OFFSET(D2,0,0,-D2)))
复制代码 公式2:- =AND((J2+6)/2*(6-J2+1)=SUM(OFFSET(J2,ROW(INDIRECT("1:"&6-J2+1))-1,ROW(INDIRECT("1:"&6-J2+1))-1)),(J2+1)/2*J2=SUM(OFFSET(J2,1-ROW(INDIRECT("1:"&J2)),1-ROW(INDIRECT("1:"&J2)))))
复制代码 公式3:- =AND((J2+6)/2*(6-J2+1)=SUM(OFFSET(J2,ROW(INDIRECT("1:"&6-J2+1))-1,1-ROW(INDIRECT("1:"&6-J2+1)))),(J2+1)/2*J2=SUM(OFFSET(J2,1-ROW(INDIRECT("1:"&J2)),ROW(INDIRECT("1:"&J2))-1)))
复制代码 只标出1,2,3,4,5,6连续的情形
Book1.rar
(8.63 KB, 下载次数: 13)
|
|