请问这种情况是什么原因？

luoheping76 · 发表于 2014-10-14 11:48

请问这种情况是什么原因？

gdw831001 · 发表于 2014-10-14 12:14

COUNTIF($C$13:$C$25,$C$13:$C$25)=COUNTIF(INDIRECT("C13:C"&COUNTA(C:C)+10),INDIRECT("C13:C"&COUNTA(C:C)+10))

luoheping76 · 发表于 2014-10-14 12:48

gdw831001 发表于 2014-10-14 12:14
COUNTIF($C$13:$C$25,$C$13:$C$25)=COUNTIF(INDIRECT("C13:C"&COUNTA(C:C)+10),INDIRECT("C13:C"&COUNTA(C: ...

谢谢！不过我试了一下，怎么计算出来是空值呢？

luoheping76 · 发表于 2014-10-14 12:50

gdw831001 发表于 2014-10-14 12:14
COUNTIF($C$13:$C$25,$C$13:$C$25)=COUNTIF(INDIRECT("C13:C"&COUNTA(C:C)+10),INDIRECT("C13:C"&COUNTA(C: ...

=IF(SUM(1/COUNTIF(INDIRECT("C13:C"&COUNTA(C:C)+10),INDIRECT("C13:C"&COUNTA(C:C)+10)))>=ROW(A1),INDEX($C$13:INDIRECT("C13:C"&COUNTA(C:C)+10),SMALL(IF(MATCH($C$13:INDIRECT("C13:C"&COUNTA(C:C)+10),$C$13:INDIRECT("C13:C"&COUNTA(C:C)+10),0)=ROW($C$13:INDIRECT("C13:C"&COUNTA(C:C)+10))-12,ROW($C$13:INDIRECT("C13:C"&COUNTA(C:C)+10))-12,""),ROW(A1))),"")
是这样吗？

gdw831001 · 发表于 2014-10-14 20:17

luoheping76 发表于 2014-10-14 12:48
谢谢！不过我试了一下，怎么计算出来是空值呢？

=IF(SUM(1/COUNTIF(INDIRECT("C13:C"&COUNTA(C:C)+10),INDIRECT("C13:C"&COUNTA(C:C)+10)))>=ROW(A1),INDEX(INDIRECT("C13:C"&COUNTA(C:C)+10),SMALL(IF(MATCH(INDIRECT("C13:C"&COUNTA(C:C)+10),INDIRECT("C13:C"&COUNTA(C:C)+10),0)=ROW(INDIRECT("C13:C"&COUNTA(C:C)+10))-12,ROW(INDIRECT("C13:C"&COUNTA(C:C)+10))-12,""),ROW(A1))),"")

复制代码

		自动登录	找回密码
密码			免费注册