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

[µo°Ý] ¦W¦r¦r¼Æ¤£¦P¤§¨ú¥N°ÝÃD¡]¤w¸Ñ¨M¡^

¦^´_ 13# GBKEE


·PÁ±z´£¨Ñªº¸ê®Æ¡I­è­è¤U¸ü¤F±zªºÀ£ÁYÀÉ¡A±NA1¦W¦r§ï¬°±i¤T¡A¬°¦ó·|¥X²{#NAME?
·Ð½Ð¦A½ç±Ð¡A·P®¦±z¡I

TOP

¦^´_ 11# toomellowhaw


­è­è´ú¸Õµ²ªG¡G
¼Ú¶§µáµá¡ã¼Ú£Aµá¡A¼Ú¶§­Å¡ã¼Ú£A­Å¡A¥q°¨¤¤­ì¡ã¥q£A¤¤

¦ý§Ú©Ò§Æ±æ±o¨ìªºµ²ªG¬O¡G
¼Ú¶§µáµá¡ã¼Ú¶§£A¡A¼Ú¶§­Å¡ã¼Ú¶§£A¡A¥q°¨¤¤­ì¡ã¥q°¨£A

¯u¬O¤£¦n·N«ä¡A¤S­n³Â·Ð±z¶O¤ß¤F¡I

TOP

¦^´_ 10# onegirl0204
¦Û­q¨ç¼Æ


½Æ©m.rar (9.94 KB)

TOP

¦^´_ 9# asimov


ÁÂÁ¡A¹L¼ú¤F¡I
ÁÙ¶·¸ò¦U¦ì¥ý¶i¦h¦h¾Ç²ß¡I
­Y¦³²¨º|©Î«ä¼{¤£©P¥þªº¦a¤è¤]½Ð¤£§[«ü±Ð..

TOP

¦^´_  toomellowhaw


«D±`·PÁ±z´£¨Ñ¥t¤@ºØ§ó²«Kªº¤½¦¡¡I¦ý¬ü¤¤¤£¨¬ªº¬O¡ã¸g´ú¸Õ«áµo²{¡A½Æ©m¦W¦r­Y¬° ...
onegirl0204 µoªí©ó 2010-10-7 11:13


=LEFT(REPLACE(A2,SUMPRODUCT(--(LEFT(A2,2)=$I$1:$I$83))+2,1,"X"),3)

½Ð¸Õ¸Õ¬Ý

TOP

¦^´_ 8# toomellowhaw


«D±`·PÁ±z´£¨Ñ¥t¤@ºØ§ó²«Kªº¤½¦¡¡I¦ý¬ü¤¤¤£¨¬ªº¬O¡ã¸g´ú¸Õ«áµo²{¡A½Æ©m¦W¦r­Y¬°¢³­Ó¦rªº¡A·|¥X²{¨Ò¦p¡ãªF¤èX±Ñ¡A¦Ó«DªF¤èX¡A¤£ª¾¬O§_¦³¸É±Ïªº¿ìªk©O¡H·Ð½Ð¦A½ç±Ð¡AÁÂÁ¡I

TOP

­É¥Îasimov¥S¤Î°¶ÔЪ©¥Dªººc·Q
=REPLACE(A2,SUMPRODUCT(--(LEFT(A2,2)=$I$1I$83))+2,1,"X")
toomellowhaw µoªí©ó 2010-10-6 06:28



toomellowhaw ¥Sªº¤½¦¡Á`¬OÅý¤HÅåÆA
¦¬¤U¾Ç²ß¤F
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¥»©«³Ì«á¥Ñ toomellowhaw ©ó 2010-10-6 06:29 ½s¿è

­É¥Îasimov¥S¤Î°¶ÔЪ©¥Dªººc·Q
=REPLACE(A2,SUMPRODUCT(--(LEFT(A2,2)=$I$1:$I$83))+2,1,"X")

TOP

¦^´_ 6# °¶ÔÐ


¯u¬O¤Ó·PÁ±z¬°§Ú¸Ñ¨M¤F°ÝÃD¡I «Ý·|Á`ºâ¥i¥H¦w¤ßºÎÅo¡I

TOP

¥»©«³Ì«á¥Ñ °¶ÔÐ ©ó 2010-10-6 02:33 ½s¿è

¦^´_ 5# onegirl0204

±NB2§ï¬°¡@=IF(LEN(A2)=2,LEFT(A2,1)&"X",IF(COUNTIF($I$1I$83,LEFT(A2,2)),LEFT(A2,2)&"X",LEFT(A2,1)&"X"&RIGHT(A2,1)))
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD