ªð¦^¦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)

²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://blog.xuite.net/hcm19522/twblog
¤w¦¬¶°8500½g EXCEL¨ç¼Æ

TOP

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

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD