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

[µo°Ý] ¦p¦ó§PÂ_¦¸¼Æ«á¡A¨Ã®æ¦¡¤ÆÀx¦s®æ?

[µo°Ý] ¦p¦ó§PÂ_¦¸¼Æ«á¡A¨Ã®æ¦¡¤ÆÀx¦s®æ?

¦U¦ì¤j¤j±z¦n¡A

·Q½Ð°Ý¡G


ÄæB¡GÂd¤l½s¸¹(¨C­ÓÂd¤l¥i¥H©ñ4­Ó¤Hªºª««~)
ÄæC¡G¦w±Æ¤H­û¥i¥H©ñ¦b­þ­ÓÂd¤l
ÄæI~ÄæM¡G1A¸Ì¬OÂd¤l½s¸¹1~30¡F2B¸Ì¬OÂd¤l½s¸¹31~60

·Q§e²{¡G
(1) ·í¦w±Æ¤H­û4­Ó¤H®É¡AÄæI~ÄæM¹ïÀ³ªºÂd¤l½s¸¹·|Åã¥Ü¶À¦â­I´º
¦Ó§Ú¸ÕµÛ¦b®æ¦¡¤ÆÀx¦s®æ±ø¥ó¤U¤½¦¡¡G¡u=SUMPRODUCT(($B$2:$B$500=I1)*(C$2:C$500<>""))=4¡v
®M¥Î¨ìÀx¦s®æ¡G¡u=$I$1:$M$17¡v
¥i¬O¦pªG«ö·Ó¥Ø«e¿é¤Jªº¸Ü¡AÂd¤l½s¸¹1©M2À³¸Ó³£·|¦P®ÉÅã¥Ü¶À¦â­I´º¤~¬O¡C(¦ý¥Ø«e¥u¦³Âd¤l½s¸¹1¦³Åã¥Ü)

(2) ©Ò¥H¥Ø«e¬O¥d¦b(1)ªº¤½¦¡³]©w¡A¦pªG¦¨¥\¥H«á¡A±N¦A¤À§O³]©w¦w±Æ¤H­û3,2,1,0¤H®É¡A­Ó§OªºÃC¦â¡C

ªþ¤WªþÀÉ¡G ·s¼W Microsoft Excel ¤u§@ªí.zip (8.17 KB)

¦]¦¹¡A·Q½Ð±Ð¤½¦¡¬O­þ¸Ì¥X²{¿ù»~©O?©Î¬O¦³§ó¦nªº¼gªk©O? ÁÂÁÂ

¥»©«³Ì«á¥Ñ n7822123 ©ó 2020-6-13 16:55 ½s¿è

¦^´_ 1# gaishutsusuru


¸Õ¸Õ¬Ý   I3=COUNTIFS($B:$B,I3,$C:$C,"*")=4

®æ¦¡¤Æ.rar (7.66 KB)

¦pªGı±oExcel¥d¹y¡A¨º´N¬O­pºâ¶q¤Ó¤j¤F¡A¦]³Ì¦h¥u¦³60*4=240­Óª««~

¥i¥H§â¤½¦¡ÁY¤p½d³ò I3=COUNTIFS($B$2:$B$241,I3,$C$2:$C$241,"*")=4


®æ¦¡¤Æ(ÁY¤p¤½¦¡½d³ò).rar (7.72 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 1# gaishutsusuru


=SUMPRODUCT(($B$2:$B$500=I3)*($C$2:$C$500<>""))

TOP

¦^´_ 2# n7822123

«D±`ÁÂÁÂn7822123¤j¤jªº¨ó§U:D

TOP

¦^´_ 3# ­ã´£³¡ªL

«D±`ÁÂÁ­㴣¤j¤jªº¨ó§U:D

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD