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

[µo°Ý] ¤G¶¥¤U©Ô¿ï³æ-¾î¦¡

[µo°Ý] ¤G¶¥¤U©Ô¿ï³æ-¾î¦¡

½Ð°ÝHsiehª©¥D,¬Q¤Ñ¨Ì¤j¤j¹ï¤G¶¥¤U©Ô¿ï³æ¤§¸Ñµª,¸ÕµÛ§ï¦¨¾î¦¡°µªk,µ²ªG¦³¥X²{¿ù»~°T®§,¦ý¤£²z·|¿ù»~°T®§,«o¥i¥H°õ¦æ,½Ðª©¥D«üÂI°g¬z

¤U©Ô¿ï³æ¤½¥qª©.rar (1.74 KB)

¤U©Ô¿ù»~°T®§.rar (51.59 KB)

©ób3¦ì¸m,­nÅçÃÒ²M³æ,¨üa3¦ì¸m¼vÅT
=OFFSET(Sheet2!$A$2,,(MATCH(Sheet1!$A3,PP,0)-1),COUNTA(OFFSET(Sheet2!$A$1,,MATCH(Sheet1!$A3,PP,0)-1,65536,))-1,)

·ía3=""®É,match³o¤@¬q·|¥X¿ù,©Ò¥HaÄ榳ªÅ¥Õªº,§¡µLªk°õ¦æ²M³æ¥\¯à
¦pªG¦³¸ê®Æ¥Bmatch¤£¥X¿ù«hÀ³¸Ó¥¿±`
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

ÁÂÁ«ü±Ð,¦A¨Ó¬ã¨s§ïµ½

TOP

¥»©«³Ì«á¥Ñ banff ©ó 2010-12-30 09:47 ½s¿è

§Ú§âSHEET1ªºA2²¾¦ÜO4¡AB2²¾¦ÜP4¡A·íµM¬ÛÃöªº°Ñ·Ó¤]¸òµÛ§ï¡Aµ²ªG¦bP4´N¤£¯à³]©w²M³æ¡]»¡¨Ó·½ªº­È¦³°ÝÃD¡^¤£ª¾¬O¦ó¦]¡HÃø¹D¥u¯à³]©w¦bA2¤ÎB2¶Ü¡H¡H

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD