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

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

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

¥»©«³Ì«á¥Ñ onegirl0204 ©ó 2010-10-10 11:16 ½s¿è

½Ð±Ð¦U¦ì«e½ú¡ã

·íexcel¸ê®ÆÄæ¸Ì¦³¤H¦W­n¨ü«OÅ@®É¡A¦p¦ó°w¹ï¦W¦r¦r¼Æ¤£¦P¦Ó¼g¥X¥¿½Tªº¤½¦¡¡H
¨Ò¦p¡G¥ÑA2¥H¤U§¡¬°¤H¦W¡A·íµM¦³¨Ç¤H¦W¬O¢±­Ó¦r©Î¢³­Ó¦rªº¡A¦p¦ó¼g¥X¥¿½Tªº¤½¦¡¨Ï³Ì«á§e²{ªº¤H¦W¬O¤ýx¡]³æ¦W¡^¡AªLx¶¯¡A¥H¤Î¼Ú¶§x¡]½Æ©m¡^¤§Ãþªº«¬ºA

·PÁ½ç±Ð¡I

ªLx¶¯¡A¥H¤Î¼Ú¶§x
°ÝÃD¦b³o¸Ì¤F¡C

TOP

ªLx¶¯¡A¥H¤Î¼Ú¶§x
°ÝÃD¦b³o¸Ì¤F¡C
oobird µoªí©ó 2010-10-5 12:36



­Ó¤H·Qªk
­º¥ý«Ø¥ß¤@­Ó½Æ©m¸ê®Æ®w
©m¦W2­Ó¦r,¨ú²Ä1­Ó¦r¬°©m
ºX³½¨ú2­Ó¦r»P¸ê®Æ®w¤ñ¹ï,§ä¤£¨ì«h¨ú²Ä1­Ó¦r¬°©m
§ä¨ì®É¨ú2­Ó¦r¬°©m
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

­Ó¤H·Qªk
­º¥ý«Ø¥ß¤@­Ó½Æ©m¸ê®Æ®w
©m¦W2­Ó¦r,¨ú²Ä1­Ó¦r¬°©m
ºX³½¨ú2­Ó¦r»P¸ê®Æ®w¤ñ¹ï,§ä¤£¨ì«h¨ú²Ä ...
asimov µoªí©ó 2010-10-5 23:07



¸É¤WÀÉ®×
¨ú©m¤ó.rar (2.5 KB)
B2=IF(LEN(A2)=2,LEFT(A2,1),IF(COUNTIF($I$1:$I$83,LEFT(A2,2)),LEFT(A2,2),LEFT(A2,1)))
±z¤£¯à¤U¸üÀÉ®×,½Ð°Ñ¦Ò¤U¹Ï
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_ 4# asimov


·PÁ±z¸Ñ¨M¤F½Æ©m°ÝÃD¡I¥i±¤°ÝÃD¥u¸Ñ¨M¤@¥b¡A¨Ì·Ó±zªº½d¨Ò¡ABÄæ¥u¥X²{©m¤ó¡A¦Ó«D¥[¤FXªº¥þ¦W¡A¬O§_½Ð±z¦A¦¸¸Ô¥[«ä¦Ò¡A¦p¦ó½s¼g¤½¦¡¥H«K±o¨ì§Ú·Q­nªºµ²ªG¡H
¤£±¡¤§½Ð¡A¬ß½Ð¨£½Ì¡I·P«ä±z¡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

¦^´_ 6# °¶ÔÐ


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

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

­É¥Î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

¦^´_ 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

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD