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

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

¥»©«³Ì«á¥Ñ 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

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD