excel 公式修改E1=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$17,MAX(6*ROW(A1)-6),6)))=6,BC110),"A","")其中C$17 是需要变化的 E2=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$23,MAX(6*ROW(A1)-6),6)))=6,BC11

excel 公式修改E1=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$17,MAX(6*ROW(A1)-6),6)))=6,BC110),"A","")其中C$17 是需要变化的 E2=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$23,MAX(6*ROW(A1)-6),6)))=6,BC11
excel 公式修改
E1=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$17,MAX(6*ROW(A1)-6),6)))=6,BC110),"A","")
其中C$17 是需要变化的
E2=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$23,MAX(6*ROW(A1)-6),6)))=6,BC110),"A","")
E3=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$29,MAX(6*ROW(A1)-6),6)))=6,BC110),"A","")
17 23 29
现在需要求解的是,如何修改公式,横着拖时,可以自动生成,不用一个一个的输入
因为有E1-E634 之多
E11=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$17,MAX(6*ROW(A1)-6),6)))=6,BC110),"A","")
其中C$17 是需要变化的
F11=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$23,MAX(6*ROW(A1)-6),6)))=6,BC110),"A","")
G11=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$29,MAX(6*ROW(A1)-6),6)))=6,BC110),"A","")

excel 公式修改E1=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$17,MAX(6*ROW(A1)-6),6)))=6,BC110),"A","")其中C$17 是需要变化的 E2=IF(AND(SUMPRODUCT(--(OFFSET(C$11,MAX(6*ROW(A1)-6),6)=OFFSET(C$23,MAX(6*ROW(A1)-6),6)))=6,BC11
看了半天你这双色球做的好讨厌,怎么个变化法?
C$17 c$23 c$29?
递增6,不能解决么
=COLUMN(A1)*6 参考下递增6
在配一个offset