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

[µo°Ý] ¦p¦ó§ì¨ú²Å¦X±ø¥óªº¹ïÀ³Äæ¦ì­È

[µo°Ý] ¦p¦ó§ì¨ú²Å¦X±ø¥óªº¹ïÀ³Äæ¦ì­È

½Ð±Ð¦U¦ì¥ý¶i~
²{¦³¤@¥÷®w¦s»P­q³æ²Î­pªº»Ý¨Dªí¡A
§Ú·QÅý¡u¥æ³f¤é´Á¡vªºÄæ¦ì¡A¯à°÷±q¡u¯ÊÃB¡vÄæ¦ì¡A¥Ñ¥ª¦Ü¥k·j´M¨ìªº²Ä¤@µ§­t¼Æ¡A¦Û°Ê±a¥X¨Ó©Ò¹ïÀ³ªº¥æ³f¤é´Á

­ì¥»¬O±Ä¥ÎIFªº¤½¦¡¡A¦ý¦]¬°Äæ¦ì·|·U¨Ó·U¦h¡Aıªº³o­Ó¤è¦¡«D±`¤£OK
¤£ª¾¥ý¶i­Ì ¬O§_¯à«üÂI«ü±Ð¦³¨S¦³§ó²©öªº§@ªk¡AÁÂÁ±z­Ì~

! ­q³æ»Ý¨Dªí.zip (10.97 KB)

°}¦C¤½¦¡:
=iferror(INDEX(SUBTOTAL(4,OFFSET(B$2,,,,COLUMN(A:O))),MATCH(1,(C4:P4<0)*(C$3:P$3="¯ÊÃB"),)),"")

TOP

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


   ÁÂÁÂ¥ý¶i~
   ¯uªº¤Ó¯«©_¤F¡A¤@¬q°}¦C¤½¦¡´N¸Ñ¨M¤F~
   §Ú±o¦n¦n®ø¤Æ¤@¤U¤F....
   «D±`ªº·PÁÂ~±z

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Î http://blog.xuite.net/hcm19522/twblog[img][/img]
¤w¦¬¶°7000½g EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522


    ÁÂÁ¤j¤j~
    ¤S¦h¾Ç¨ì¤@ºØ¤è¦¡¤F~

TOP

¦^´_ 5# chi830



    2¼Ó "­ã¤j®v" ¬O¤j®v¤¤ªº¤j®v  ¦¹¤è¦¡´¿½Ð±Ð©ó¥L
ÀH·NºÛ "EXCEL°g"  blog  ©Î http://blog.xuite.net/hcm19522/twblog[img][/img]
¤w¦¬¶°7000½g EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD