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

[µo°Ý] °ÊºA¥[Á`

[µo°Ý] °ÊºA¥[Á`

¦³¨S¦³¤°»ò¨ç¼Æ
©Î¬O¤èªk¥i¥H¦b¨â­ÓÃþ§O¤¤´¡¤J¦C³£¯à°ÊºAªº¥[Á`¼Æ¶q

°ÊºA¥[Á`.zip (7.87 KB)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-2-1 09:24 ½s¿è

¦^´_ 1# imzues

ÂIC3Àx¦s®æ
©w¸q¦WºÙx=LOOKUP("ùÕ",'18B'!$C$2:$C2,ROW('18B'!$2:2))  '©¹¤W§ä¨ì¤å¦rªº¦ì¸m
¤ë­p¤½¦¡
=SUM(INDIRECT("R"&x&"C:R[-1]C",0))  '¥[Á`°ÊºA½d³ò(ÀHµÛx­È°µ¬°°_ÂI)
°ÊºA¥[Á`.rar (6.05 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³o¦ì¤j¤j§Ú²Ä¤@¦¸¬Ý¹L³oºØ¥Îªk
¤£¤ÓÀ´,¥i¥H¸ÑÄÀ¤@¤U¶Ü?

TOP

¦^´_ 2# Hsieh
·q½Ð¶W¯Åª©¥D«ü¾É¡AÁÂÁ¡I
¡uùÕ¡v«ç»òKEYIN¥X¨Ó¡H¡uùÕ¡v¤S¥Nªí¤°»ò·N¸q¡H
µù¡G¦bExcel 2007»¡©ú¤¤§ä¤£¨ì¡uùÕ¡v

TOP

¦^´_ 4# p212

"ùÕ"­µ£y£«£¿
¦b¤º½Xªí¤º±Æ§Ç³Ì¤jªºÁcÅ餤¤å¦r
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD