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

[µo°Ý] ¨D±Ð¥t¥~¤@ºØ®w¦s®Ö¹ï¼gªk

[µo°Ý] ¨D±Ð¥t¥~¤@ºØ®w¦s®Ö¹ï¼gªk

¦]»Ý¤ñ¹ï¨C¤ë®w¦s®Æ¸¹¡A¥Ø«e§@ªk¬O¥H·í¤ë¥H¥D¡A¥ýmatch«e´X¤ëªº®Æ¸¹(D¡BFÄæ)¡AµM«á¦A¥Îif§PÂ_¸Ó®Æ¸¹¬OÄÝ©ó­þ¤ë¥÷¶}©lªº®w¦s(BÄæ)¡A¦ý¨ì¥Ø«e¬°¤î¡A¨C¤ë³£­n¤ñ¹ï¡Aif¤w¥Î¨ì7¼hªº¤W­­¡A¬G·Q½Ð±Ð¬O§_¦³¥t¥~¤@ºØ¼gªk§PÂ_
®Æ¸¹®w¦s®Ö¹ï.zip (3.81 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2013-11-18 14:14 ½s¿è

¦^´_ 1# paddyliu
½Ð°Ñ¦Ò¡I

Fig.JPG (98.21 KB)

Fig.JPG

®Æ¸¹®w¦s®Ö¹ï_°Ñ¦Ò.zip (4.36 KB)

TOP

¦^´_ 2# p212
¦ý®Æ¸¹¨Ã¨S¦³§Ú¨Ò¤l¤¤ªº¨º»ò¤Ö¡A¦pªG¨C¤ë³£¥Î°ïÅ|¨ì¥Ø«e¬°¤î´N¸Uµ§¤F¡A
¯à§_ÁÙ¦³¥Î¨Ã¦Cªº¨ä¥¦¼gªk¡H

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-11-19 14:37 ½s¿è

¦^´_ 3# paddyliu
¸ê®Æ½Ð©¹¤U¶K¡A¤½¦¡©¹¤U½Æ»s¡A¥i§_¡H
©¹¥kµo®i¡A¥i¯à·|¤£º¡¨¬¸ê®Æ¶q¤jªº»Ý¨D¡A½Ð°Ñ¦Ò¡C

TOP

¦^´_ 3# paddyliu
¬O­n¼g¦p¹ÏBÄ檺¤½¦¡¶Ü?

B2°}¦C¤½¦¡
=IF(COUNTIF(OFFSET($C$1,,,COUNTA($C:$C),COUNTA($1:$1)),$A2)=0,$A$1,INDIRECT("R1C"&MAX(IF(OFFSET($C$1,,,COUNTA($C:$C),COUNTA($1:$1))=$A2,COLUMN(OFFSET($C$1,,,COUNTA($C:$C),COUNTA($1:$1))),"")),0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD