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

[µo°Ý] Excel­pºâ©Ò¦û¤§­±¿n

[µo°Ý] Excel­pºâ©Ò¦û¤§­±¿n



AÄæ¦ì¬° ºô®æªº½s¸¹( 1-1200 )
BÄæ¦ì¬°¤g¦a§Q¥ÎÃþ«¬ªº½s¸¹( 01-09 )
CÄæ¦ì¬°¦U¤g¦a§Q¥ÎÃþ«¬©Ò¥eªº­±¿n

²{¦b·Q­n­pºâ
¦b¨C­Óºô®æ¤¤ ¦U­Ó¤g¦a§Q¥ÎÃþ«¬¤§­±¿n©M
¦p¤U¦p©Ò¥Ü


½Ð°Ý¦³¤Hª¾¹D¸Ó«ç»ò­pºâ¶Ü?
·PÁ±z:)

¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-29 14:23 ½s¿è

¦^´_ 1# peter800725
¥i§_¤W¶ÇÀɮװѦҡH¤è«K¦U¦ì¦P¾Ç¤@°_¬ã¨s¡AÁÂÁ¡I

TOP

¦^´_ 1# peter800725


    §AÀ³¸Ó­nÁ|­Ó¨Ò¤l¡A³o¼Ë¤j®a¤~ª¾¹D§A©Ò­nªºªF¦è¦p¦ó­pºâ¡Aµ²ªG¬°¦ó¡A
    ¤~¦³¿ìªkÀ°§A·Q­n¦p¦ó¥h³]©w¤½¦¡¡C

TOP

¥Î¼Ï¯Ã©Ô¤@©Ô´N¥i¥H¤F

TOP

ªþ¥ó¬°§ÚªºÀÉ®×
¼Ë°Ïºô®æ¤g¦aunion.rar (707.12 KB)

²³æ¨Ó»¡§Ú¬O§Q¥ÎGIS¦a²z¸ê°T¨t²Î
¥ý±N°Ï°ì¹Ï(¶mÂí¥«¹Ï¼h)©ñ¤W¥h
¦A¥[¤J¤g¦a§Q¥Îªº¹Ï¼h( ¦@9ºØ¤g¦a§Q¥Î±¡§Î) 96¦~°ê¤g§Q¥Î½Õ¬d¸ê®Æ
±µ¤U¨Ó±N¤W­zºô®æ¤Æ
¤Á¦¨ 100M* 100M ¤§ºô®æ
¨C­Óºô®æ·|¥]§t¦UºØ¤g¦a§Q¥Î¤§Ãþ«¬
¨Ã­pºâ­Ó¤g¦a§Q¥ÎÃþ«¬¦b¦U­Óºô®æ©Ò¥eªº­±¿n

¹w­p§Q¥Î84¦~»P96¦~°ê¤g§Q¥Î½Õ¬d§ä¥X¤g¦a§Q¥ÎÃþ«¬«e«á¤§ÅܤÆ

ÁÂÁ¤j®a :D

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-11-1 12:29 ½s¿è

¦^´_ 5# peter800725
½Ð¦b¡u­pºâ¦Uºô®æ¦U¤g¦aÃþ«¬­±¿nÁ`©M¡v¤u§@ªí (ªþ¥ó²Ä2­Ó¤u§@ªí) ¤§B2Àx¦s®æ¿é¤J

=SUMIFS(¼Ë°Ïºô®æ¤g¦aunion!$E:$E,¼Ë°Ïºô®æ¤g¦aunion!$A:$A,­pºâ¦Uºô®æ¦U¤g¦aÃþ«¬­±¿nÁ`©M!$A2,¼Ë°Ïºô®æ¤g¦aunion!$B:$B,­pºâ¦Uºô®æ¦U¤g¦aÃþ«¬­±¿nÁ`©M!B$1)

©Î

=SUMIFS(¼Ë°Ïºô®æ¤g¦aunion!$E:$E,¼Ë°Ïºô®æ¤g¦aunion!$A:$A,$A2,¼Ë°Ïºô®æ¤g¦aunion!$B:$B,B$1)

¦A¦V¥k¡B¦V¤U½Æ»s§Y¥i¡A½Ð°Ñ¦Ò¡I

TOP

¦^´_ 6# p212


·PÁ±z:)
§Ú©ú¤Ñ¨ì¬ã¨s«Ç«á¦A¾Þ§@¬Ý¬Ý
¦p¦³°ÝÃD§Ú¦b¤W¨Ó¦V±z½Ð±Ð

TOP

¦^´_ 7# peter800725
¼Ï¯Ã¬O¦nªº¿ï¾Ü

play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh

·Pı«Ü§Ö³tXD
©ú¤Ñ§Ú³£¨Ó¸Õ¸Õ¬Ý
·PÁ§AÅo~~

TOP

¦^´_ 1# peter800725


    ¤u§@ªí:­pºâ¦Uºô®æ¦U¤g¦aÃþ§O¤§¤À§O­±¿n

­ì¤½¦¡
B2 =VLOOKUP($B$1,¼Ë°Ïºô®æ¤g¦aunion!B2:E2,4,FALSE)

¥i§ï¬°
B2 =IF(B$1=¼Ë°Ïºô®æ¤g¦aunion!$B2,¼Ë°Ïºô®æ¤g¦aunion!$E2,"")


B2¤½¦¡ ¥k©Ô¤U©Ô½Æ»s



¤u§@ªí:­pºâ¦Uºô®æ¦U¤g¦aÃþ«¬­±¿nÁ`©M

B2 =SUMIFS(¼Ë°Ïºô®æ¤g¦aunion!$E:$E,¼Ë°Ïºô®æ¤g¦aunion!$A:$A,$A2,¼Ë°Ïºô®æ¤g¦aunion!$B:$B,B$1)

B2¤½¦¡ ¥k©Ô¤U©Ô½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD