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

[µo°Ý] ¤G¶¥¤U©Ô¿ï³æ-¥i¥[¸ê®Æ

[µo°Ý] ¤G¶¥¤U©Ô¿ï³æ-¥i¥[¸ê®Æ

¥»©«³Ì«á¥Ñ kuigod ©ó 2010-12-26 13:03 ½s¿è

¤G¶¥¤U©Ô¿ï³æ-¥i¥[¸ê®Æ





"¤@²Õ" - ¥i¥¿±`¨ú±o¹ïÀ³¸ê®Æ

¦ý "¤G²Õ" ¤Î "¤T²Õ" (©Î¦h²Õ)..... , µLªk¨ú±o¹ïÀ³¿ï¨ú¸ê®Æ,
¥i¯à¦b WW=OFFSET(Data!$A2,,(MATCH(Worksheet!$B4,QQ,)-1),COUNTA(OFFSET(Data!$A:$A,,(MATCH(Worksheet!$B4,QQ,)-1)))-1) ¥X°ÝÃD?
¥u¦^¶Ç "¤@²Õ" ¿ï¨ú¸ê®Æ

·Q¤F«Ü¤[¤´¤£³q, ¨D±Ð.

¤G¶¥¤U©Ô¿ï³æ-¥i¥[¸ê®Æ.rar (10.69 KB)

ww=OFFSET(Data!$A2,,(MATCH(Worksheet!F$4,QQ,0)-1),COUNTA(OFFSET(Data!$A$1,,MATCH(Worksheet!F$4,QQ,0)-1,65536,))-1,)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ kuigod ©ó 2010-12-27 01:38 ½s¿è
ww=OFFSET(Data!$A2,,(MATCH(Worksheet!F$4,QQ,0)-1),COUNTA(OFFSET(Data!$A$1,,MATCH(Worksheet!F$4,QQ,0) ...
Hsieh µoªí©ó 2010-12-26 18:29



Hsieh ¶W¯Åª©¥D.

©ó¸ê®ÆÅçÃÒ¿é¤J¨ç¼Æ«á, ¦A©ì©ñ¦h­ÓÀx¦s®æ, ¦¨¥\©ó¦P¤@sheet¤º§@¦h²Õ¤£¦P¹ïÀ³¿ï¨ú!



¸U¤À·PÁÂ!

¥ý¦¬¤U:) ºCºC¦A¬ã¨s¤Î¾Ç²ß.

kuigod

TOP

§Ú°O±oÁÙ¦³¤@­Ó¸g¨å¤U©Ô¦¡®×¨Ò,²Ä¤@­Ó¤U©Ô¦¡ªº¿ï¾Ü,·|¼vÅT²Ä¤G­Ó¤U©Ô¦¡ªº¿ï¾Ü¶µ¥Ø
§ä¨Ç®É¶¡¼g¤@­Ó¶K¤l
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

«z¡I³o»ò½ÆÂø  ÁöµM¤£¯à¤U¸ü  ¥Î³o­Ó¤½¦¡  ¨Ó¸Õ¸Õ  ÁÂÁ§A

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD