ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó­pºâ¥XAÄæ"³sÄò"ªº0¸ò1¤§¶¡¦³´X­Ó0

[µo°Ý] ¦p¦ó­pºâ¥XAÄæ"³sÄò"ªº0¸ò1¤§¶¡¦³´X­Ó0

·Ð½Ð«e½úÀ°­Ó¦£¦p¦ó­pºâ "³sÄò"ªº0¸ò1¤§¶¡ ¦³´X­Ó0

­pºâ¥X³sÄòªº0¸ò1¤§¶¡¦³´X­Ó0.png
2017-5-8 14:01


´£°Ý­pºâ0.rar (8.51 KB)

E4 : E33
{=FREQUENCY(FREQUENCY(IF(A1:A130=0,ROW(1:130)),IF(A1:A130>1,ROW(1:130))),MOD(ROW(1:31),31)) }
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

²q²q¬Ý{=SUM((FREQUENCY(IF(A$1:A$130<2,ROW(A$1:A$130)),IF(A$1:A$130>1,ROW(A$1:A$130)))=ROW(A1))*1)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD