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

¯à§_´î¤Ö­pºâ®É¶¡

¯à§_´î¤Ö­pºâ®É¶¡

±z¦n:

§Ú¨Ï¥Îsumif¤½¦¡´M§ä487~4666²Å¦Xªº¶µ¥Ø¨Ã°µ¥[Á`
Á`¦@¨Ï¥Î424¦¸ªºsumif¤½¦¡
­pºâ®É¶¡¬Û·í¤[
¤£ª¾¦³¨S¦³¤°»ò¤èªk¥i¥H´î¤Ö­pºâ®É¶¡
¥t·j´M±ø¥ó³]­p¦³ÂI³Â·Ð, ¦p¤U:
"*"&$A51&"-"&B$49&"*"

¦³·Q¹L¨Ï¥Îsumproduct, ©Î¨Ï¥Î°}¦C¤½¦¡
¦ý¸Õ¤£¥X¨Ó
¤£ª¾¬O¤½¦¡¼g¿ùÁÙ¬O¤°»ò­ì¦]
¥i§_½Ð¤j®a«ü¾É¦³¤°»ò¤è¦¡¥i¥H°µ¨ì¬Û¦Pªº¥\¯à¤S¯à´î¤Ö¹Bºâ®É¶¡

sumif¥²©w¤ñsumproduct©Î°}¦C¤½¦¡§Ö¡C
ºCªº­ì¦]¥²¦³¨ä¥L¦]¯À¼vÅT¡I

TOP

¤j¸ê®Æ¶q¡A¤j¶qªº¤½¦¡¡A¤£¥iÁקKªº³t«×«ÜºC¡A¯uªº¥i¥H¦Ò¼{¥ÎVBA¡I

TOP

½Ð°Ý¥Î¤FVBA¯uªº­pºâ³t«×¥i¥HÅܧֶܡH§Ú¤£·|VBA©Ò¥H°Ý³o­Ó²Â°ÝÃD¡A¤£¦n·N«ä!!
marklu

TOP

¦^´_ 4# lumark1976

¤j¶q¤½¦¡¤×¨ä¬O°}¦C¤½¦¡·|©ì²Ö¹Bºâ¬O¤£ª§ªº¨Æ¹ê
­Y¬O¸ê®Æ¶q¤j·íµM¨Ï¥Îvba»²§U¥i¤@¦¸©Êªº§¹¦¨­pºâ
¦pªG¨Ï¥Î°}¦C¤½¦¡¨º»ò¨C­ÓÀx¦s®æ¹Bºâ³£¥²¶·§¹¦¨¸ê®Æ¶qÁ`¼Æ°j°é
¥Lªº³t«×·|ºC¬O¥i·Q¦Óª¾
¬O§_«D±o¨Ï¥Îvba·íµM¤]¥¼¥²
µ½¥Îexcel¤º«Ø¥\¯à¦³§U©ó¤½¦¡ªº¹B¥Î
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

VBAÁÙ¤£¤Ó·|¨Ï¥Î
«e°}¤l©M¦P¨Æ¤p¸Õ¤@¤U...§óºC

¤£ª¾¬O¤£¬O­pºâªº¤èªk¤Ó²ÂÁÙ¬O«ç¼Ë
³Ìªñ·Q»¡¥ý¥Î¤½¦¡¾ã²z¤@¦¸¸ê®Æ¦A¥Î¼Ï§á¤ÀªRªí¾ã²z¦¨§Ú­nªº³Ì²×µ²ªG
¤p¸Õ¤@¤U...³t«×§Ö«Ü¦h
¦ý¥X¨Óªº·Pı©M§Ú·Q­nªº·Pı¦³ÂI¸¨®t

TOP

¥»©«³Ì«á¥Ñ mistery ©ó 2010-12-22 12:03 ½s¿è

¦^´_ 6# vvcvc


    ¥i¬Ý¤@¤U¹ê¨Ò¶Ü?

TOP

¥»©«³Ì«á¥Ñ vvcvc ©ó 2010-12-23 22:53 ½s¿è

¦]¬°¬O¤½¥qªº¸ê®Æ
¤£¤Ó¤è«K¶K¤W¨Ó
RAW DATA¤S¤Ó¦h...1~2¸U¦æ
¤£¹L§Ú¥u»Ý­n¨ä¤¤¬ù6000¦æªº¸ê®Æ¥[Á`
­pºâ«á°µ¦¨ªí®æ

TOP

§A¥i¥H¦Û¦æ¼ÒÀÀ¤@­Ó¤å¥óµo¤W¨Ó§r¡I»¡ªº¼Ò¼Ò½k½k·QÀ°§A³£Ãø¡I

TOP

¥H«e³£¬O³o¼Ë¤l¤W¨Ó°Ýªº
¦ý³o¦¸¸ê®Æ¶q¹ê¦b¬O¤j¨ì§Ú¤£ª¾¹D«ç»ò¼ÒÀÀ(¦Ó¥BÅܤƤ]«Ü¦h)
©Ò¥H¤~·|¦Û¤v¨ì³B¬Ý¬Ý¦³¨S¦³¤°»òÂI¤l¥i¥H¥Î
«e°}¤l¬Ý¨ì¼Ï§á¤ÀªRªí·PıÀ³¸Ó·|¦³À°§U
¸Õ°µ¤@¤U...®ÄªG¯uªºÁÙ¤£¿à
¥u¬O§e²{¥X¨Óªº®ÄªG©M§Ú·Q­nªº¦³ÂI¸¨®t
ÁÙ¦b§V¤O§ä¼Ï§á¤ÀªRªíªº¾Þ§@¹ê¨Ò¤Î±Ð¾Ç¤¤

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD