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

¦h­«ÅçÃÒ

¦h­«ÅçÃÒ

¥»©«³Ì«á¥Ñ missbb ©ó 2013-11-8 00:37 ½s¿è

¦U¦ì, ½ÐÀ°¦£.

·Q°µEXCEL³ø¦Wªí

¦b¨C¦C¿é¤J¦h­«ÅçÃÒ¸ê®Æ:
1) ¨C¤H¦b©Ò¿ï¯Z§O¿é¤J1.
2) ¨C¤H¨C¦C¥u¥i¿é¤J1¦¸©Î¤£¿é¤J.
3) ¤£¥i¿é¤J1¥H¥~¼Æ¦r (¦ý´¿¸Õ¿é¤J1«á, ·Q§ó§ï®É±N¤§§ï¬°0©Î¥ÎSPACEBAR²MªÅ, ¤´µM¥X²{¿ù»~°T®§)
4) ¦p¸Ó¯Z"¤w³ø¦W¤H¼Æ"¤j©ó¤©³]"¨C¯Z¤W­­¤H¼Æ", ±N¤£¥i¦b¦P¤@¯ZªºÄ椺¦A¿é¤J.

¦³ÀÉ®×¥i¥H¬Ý¶Ü

TOP

¦^´_ 2# guaga

1.png (8.91 KB)

1.png

1.png (8.91 KB)

1.png

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2013-11-8 15:14): excel¥²¶·À£ÁY¤~¯à¤W¶Ç

guaga
¹ï¤£°_, ¤£ª¾«ç¼Ë¤W³ÅEXCEL ÀÉ.

TOP

¦^´_ 4# missbb

¦^´_¤¤ ¦³ªþ¥ó  ¥i¥HªþÀÉ®×
§Aªº·N«ä¬O ¦b²Ä¤@¯Z ³Ì¦h¥u¯à¿é¤J3¤H
²Ä¤G¯Z5¤Hªº·N«ä¶Ü

TOP

¦^´_ 4# missbb
ÅçÃÒ¦Û­q¤½¦¡
=(SUM(OFFSET(B$6,,,COUNTA($A$6:$A$65536),))<=B$1)*(SUM(OFFSET($B6,,,1,COUNTA($5:$5)-1))<=1)
   
¦h­«ÅçÃÒ.zip (5.04 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP



¿ï¨úB6:D16½d³ò¡A¤u¨ã¦C - ¸ê®Æ - ¸ê®ÆÅçÃÒ - ³]©w - Àx¦s®æ¤º¤¹³\(¿ï ¦Û­q) - ¤½¦¡(¦p¤U)

ÅçÃÒ¦Û­q¤½¦¡
=SUM(INDIRECT("R6C:R16C",))<=B$1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦³­ì©lÀɸû¯à§¹¾ãª¾¹Dª©¥Dªº·N«ä

TOP

¥»©«³Ì«á¥Ñ missbb ©ó 2013-11-9 13:24 ½s¿è

¦^´_ 6# Hsieh

¦U¦ì¤j¤j:

¹ï¤£°_, ¤´µM¤£¯à¤W¸ü©Î¤U¸üEXCEL.ZIP
¦ý§Ú¿é¤J¤U¦CÅçÃÒ, ·í¿é¤J1®É, Åã¥Ü¿ù»~°T®§.

(sum(offset(b$6,,,counta($a$6:$a$16),))<=b$1)*(SUM(OFFSET($b6,,,1,counta($5:$5)-1))<=1)

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-11-10 22:15 ½s¿è

¸g¹L¦A¦¸´ú¸Õ, §Ú³Ì«á¤]¦¨¥\¤F. ¦hÁÂHsieh «ü¾É¤Î¦U¦ì:

¦¨¥\ÅçÃÒ¦Û­q¤½¦¡
=(SUM(OFFSET(B$6,,,COUNTA($A$6:$A$65536),))<=B$1)*(SUM(OFFSET($B6,,,1,COUNTA($5:$5)-1))<=1)

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD