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

[¤À¨É] ©w¸q¦WºÙªº°g«ä

¾Ç¨ì·sªF¦è¤F,ÁöµM¬Ýªº²´ªá¼º¶Ã,ÁÂÁÂ
Jeffrey Chen

TOP

Àò¯q¨}¦h  ¨Ó¸Õ¸Õ¬Ý ·PÁ¤À¨É

TOP

¥»©«³Ì«á¥Ñ Happkkevin ©ó 2011-6-26 05:04 ½s¿è

ÁÙ¦b¬ã¨s³o½g¤å¡A¦ýÅv­­ÁÙµLªk¤U¸üªþ¥ó¡A¬ã¨s¤å¦r±Ô­z¤¤
¦ýÃö©óµ´¹ï°Ñ·Ó¦ì§} »P¬Û¹ï°Ñ·Ó¦ì§}¡A¬OVBA °ò¥»·§©À»P ¨ç¼Æ«Ü­«­nªº¤¸¯À
¦b¨ç¼Æ¨Ï¥Î¡A§Ú±`±`¥Î¨ì¡A¤À¨É­ÓÀ³¸Ó±`¥Î¨ì¦ýªì¾ÇªÌ¥i¯à±`¤£ª¾ªº§Ö³tÁä
¿ï¨ú±ý§ó§ïªº¹ï¶H¡A¦p¨ç¼Æ¤¤ªºA1¡A¤£¶·¿é¤J$¡A¨Ï¥ÎF4Áä§Ö³tÅÜ´« ©ó$A$1¡BA$1¡B$A1¡BA1¡B$A$1¡B¡B¡B

·PÁ¤À¨ÉÃö©ó¦WºÙÀ³¥Î¡A©ó¨Ï¥Î¨ç¼Æ¥i¥H¶¥¼h¤ÀªR«á¡A±N¦@¥ÎªÌ¥H¦WºÙ¾É¥X²¤Æ¨ç¼Æ»P«K©ó¸ÑŪ
¥u¬O¬Ý¨ì«e½úªº¨Ï¥Î¡A§ÚÁÙ¦³«Ü¦h¥i¥Hºë¶iªº¦a¤è¡A¨ü±Ð¤£¤Ö¡A·P®¦

TOP

·PÁ¤À¨É¡AÅý§ÚªºEXCEL¥\¤O¤j¼W
Kenny

TOP

Åý¦WºÙªð¦^·í«e¤u§@ªíªº¤@­Ó§Þ¥©

³o­Ó§Þ¥©ÁÙ¨S¬Ý¨ì¤§«e¯uªº§xÂZ§Ú¦n¤[
ÁÂÁ¤À¨É
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¯uªº¦³ÂI½ÆÂø¡A
¦n¦n¨Ó¾Ç²ß¾Ç²ß¡C
ÁÂÁ±zªº¤À¨É¡C

TOP

¥»©«³Ì«á¥Ñ infoverdad ©ó 2011-9-3 11:13 ½s¿è

¦^´_ 1# Hsieh


ÁÂÁª©¤jµL¨pªº¤À¨ÉÅý§Ú­Ì¨ü¯q¨}¦h!!
¦ýªþ¥ó¤¤ªº¤½¦¡¥Hµ´¹ï¦ì§}$H$1ªº¦a¤è¬O§_¶·µy§@½Õ¾ã(§ï¦¨$H1)?
1.¤u§@ªí"Original"   rr=MATCH(Orginal!$H$1,Original!$A:$A,0) =>
¤u§@ªí"revised"      rr=MATCH(revised!$H1,revised!$A:$A,0)

2. j1¸ê®ÆÅçÃÒ·Ç«h¡i¨Ó·½¡j
=OFFSET($A$1,MATCH($H$1,$A:$A,0)-1,1,,COUNTA(INDIRECT("B"&MATCH($H$1,$A:$A,0)&":F"&MATCH($H$1,$A:$A,0)))) §ï¦¨
=OFFSET($A$1,MATCH($H1,$A:$A,0)-1,1,,COUNTA(INDIRECT("B"&MATCH($H1,$A:$A,0)&":F"&MATCH($H1,$A:$A,0))))

¤G¶¥¿ï³æ_­×.rar (54.48 KB)

TOP

¦^´_ 17# infoverdad

¦hÁ«ü¥¿¡A¨S¿ù¦CÀ³¸Ó¨Ï¥Î¬Û¹ï°Ñ·Ó¡A¤~·|ÀHµÛ¦P¦CÅܤƲM³æ
ªþ¥ó¤w§ó·s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

T(NOW())....
³o¦n¦ü»¡.½a«hÅÜ.ÅÜ«h³qªº¹D²z

TOP

Ãú¸Ì¬Ýªá
¸Ó¨Ó¥h¶R®Ñ½¤@µf
ÁÙ°±¯d¦b¨Ï¥Î²³æ¨ç¼Æªº¶¥¬q
µæ³¾¤@ªT

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD