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

[µo°Ý] ¸õ¦C·j´M¨Ã²Î­p­Ó¼Æªº¨ç¼Æ¤½¦¡

[µo°Ý] ¸õ¦C·j´M¨Ã²Î­p­Ó¼Æªº¨ç¼Æ¤½¦¡

¸õ¦C·j´M¨Ã²Î­p­Ó¼Æ.png
2018-4-22 07:26

´ú¸ÕÀÉ
¸õ¦C·j´M¨Ã²Î­p­Ó¼Æ.rar (9.89 KB)

¤å¦r»¡©ú:
V2
=IF(COUNTIF($K$8:$Q$8,V$1)=0,"",COUNTIF($K$8:$Q$8,V$1))
V3
=IF(COUNTIF($K$16:$Q$16,V$1)=0,"",COUNTIF($K$16:$Q$16,V$1))
¡J
¡J
V8
=IF(COUNTIF($K$56:$Q$56,V$1)=0,"",COUNTIF($K$56:$Q$56,V$1))


V10
=IF(COUNTIF($K$7:$Q$8,V$1)=0,"",COUNTIF($K$7:$Q$8,V$1))
V11
=IF(COUNTIF($K$15:$Q$16,V$1)=0,"",COUNTIF($K$15:$Q$16,V$1))
¡J
¡J
V16
=IF(COUNTIF($K$55:$Q$56,V$1)=0,"",COUNTIF($K$55:$Q$56,V$1))


V18
=IF(COUNTIF($K$6:$Q$8,V$1)=0,"",COUNTIF($K$6:$Q$8,V$1))
V19
=IF(COUNTIF($K$14:$Q$16,V$1)=0,"",COUNTIF($K$14:$Q$16,V$1))
¡J
¡J
V24
=IF(COUNTIF($K$54:$Q$56,V$1)=0,"",COUNTIF($K$54:$Q$56,V$1))

¨ä¾l°Ï¶ô½d³ò¤½¦¡........Ãþ±À


¥Ø«e¬O¨C­Ó°Ï¶ô½d³òªº·j´M¨Ã²Î­p­Ó¼Æªº7¦C¤½¦¡¤À§O¼g¤@¦¸¡A
·Q±N¨C­Ó°Ï¶ô½d³ò¤§²Ä1®æ¤½¦¡Â²¤Æ¦¨¯à¤U©Ô¤@¦¸¨ì¦ìªº¤½¦¡¡C

½Ð±Ð¡J
¨C­Ó°Ï¶ô½d³ò¸õ¦C·j´M¨Ã²Î­p­Ó¼Æªº¤½¦¡­n¦p¦ó½s¼g?
ÁÂÁÂ!

¥»©«³Ì«á¥Ñ papaya ©ó 2018-4-22 12:03 ½s¿è

¦^´_ 6# hcm19522
ÁA¸Ñ¤F!
·PÁ±zªº¼ö¤ß´£¿ô©M«ü¾É^^

­ãª©¥D®æ¦¡³]©w#¡A¤]¬O¥i¥HV2¥k²¾¤U©Ô¤@¦¸¨ì¦ì¡AªÅ¥Õ¦C¥çÅã¥ÜªÅ¥Õ^^
±z­Ì³£¤Ó¯«¤F!

TOP

¦^´_ 5# papaya

2¼Ó "­ã¤j¤j" +TEXT(­ì¤½¦¡ ,"0;;") ¥ç OK
OR ¦Û­q-->0;;
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522
·PÁ±zªº¼ö¤ß«ü¾É!
¤Ó¼F®`¤F¡A¤½¦¡¤£¶È¥i¤@¦¸©¹¤U¨ì¦ì¡A¥B¥i¦Û°ÊÅã¥ÜªÅ¥Õ¦C¡C
¥»½×¾Â¯u¬O°ª¤â¦p¶³^^

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# ­ã´£³¡ªL
·PÁª©¥Dªº¼ö¤ß«ü¾É!
¤Ó¯«¤F¡A¤@­Ó¤½¦¡³º¯àÀ³¥Î¦Ü¥þ³¡ªº¦C¼Æ^^

TOP

=COUNTIF(OFFSET($K$1,8-INT(ROW(A8)/8)+MOD(ROW()-2,8)*8,,ROW(A8)/8,7),V$1)

­Y¤£·QÅã¥Ü0­È, ¦Û¥[IF±Æ°£, ©Î®æ¦¡³]¬°"#"

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD