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

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

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

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

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

QQ and WW.jpg
2010-12-26 12:36


Data.jpg
2010-12-26 12:54


"¤@²Õ" - ¥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)

¥»©«³Ì«á¥Ñ 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¹ïÀ³¿ï¨ú!

w5.jpg
2010-12-27 01:31


¸U¤À·PÁÂ!

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

kuigod

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD