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

[µo°Ý] ¦p¦ó¨Ì¡u¶m¡v¡B¡uÂí¡v¡B¡u¥«¡v¡B¡u°Ï¡v³]©w¤½¦¡¤Á³Î¸ê®Æ

[µo°Ý] ¦p¦ó¨Ì¡u¶m¡v¡B¡uÂí¡v¡B¡u¥«¡v¡B¡u°Ï¡v³]©w¤½¦¡¤Á³Î¸ê®Æ

½Ð°Ý¦U¦ì«e½ú
¦p¦ó¨Ì¡u¶m¡v¡B¡uÂí¡v¡B¡u¥«¡v¡B¡u°Ï¡v³]©w¤½¦¡¤Á³Î¸ê®Æ¡H
fig.jpg

¦a§}¤Á³Î.zip (11.45 KB)

=LOOKUP(1,0/FIND(MID(B3,{5,6,7},1),"¶mÂí¥«°Ï"),LEFT(B3,{5,6,7}))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 1# p212


    D3=LEFT(B3,MIN(FIND({"¶m","Âí","¥«","°Ï"},B3&"¶mÂí¥«°Ï",5)))¡A¤U©Ô
find ¤U 5 ªí¥Ü±q²Ä5­Ó¦r¤¸¶}©l·j´M¡A¬O°t¦X¥xÆW¦a§}ªº±¡§Î¡A³Ìµu¤j·§¬O²Ä5¦r¤¸¡A¨Ò¥x«n¥«ªF°Ï

TOP

¦^´_ 2# hcm19522
ÁÂÁÂhcm19522¤jªº«ü¾É

TOP

¦^´_ 3# KCC
ÁÂÁÂKCC¤jªº«ü¾É

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-4-12 16:50 ½s¿è

¦^´_ 4# p212

2F  "¶mÂí¥«°Ï" «á­±¦³¦¹¥|­Ó¦r¤¸ªº§ø¨½µó¹D¦W ,¦³»~
3F  ¸û¨Î ,¥xÆW¥Ø«e¿¤¶mÂí¦W ,¥u¦³¥­Âí¥« ,¤Ö¤@­Ó "¥«" ,§ø¨½µó¹D¦W¦³¦¹¥|­Ó¦r¤¸¾÷·|¸û¦h
http://blog.xuite.net/hcm19522/twblog/498536647
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2017-4-13 10:04 ½s¿è

¦^´_ 6# hcm19522
ÁÂÁÂhcm19522 ¤jªº²Ó¤ß»PÃöª`¡A
³o¨Ç¤Á³Î«áªº¦í§}¸ê®Æ¡A¬O¤½³¡ªù¡u¶mÂí¥«°Ï¥N½X¡vªº¹ïÀ³¸ê®Æ¡A¨ä¤¤·|¦³¡u¼ê´ò¿¤°¨¤½¥«1¡v¡B¡u¼ê´ò¿¤°¨¤½¥«2¡vµ¥¤§ª¬ªp¥X²{¡A1#°Ý¤¤¥¼¤©´£°Ý¡A¹B¥Î2#¤Î3#ªº²Õ¦X¤½¦¡¬ÒµLªk¶¶§Q¤Á³Î¡A½Ð°ÝÀ³¦p¦ó³B¸m¬O¦n¡H
·q½Ð«ü±Ð¡AÁÂÁ¡I
fig2.jpg

¦a§}¤Á³Î_2.zip (11.81 KB)

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2017-4-13 11:54 ½s¿è

=LEFT(B3,-LOOKUP(,-FIND({"¶m","Âí","¥«","°Ï"},B3)))&LOOKUP(,-FIND({"","¥«1","¥«2"},B3),{"",1,2})

¥­Âí¥«
¥x«nÁÙ¦³­Ó ·s¥«°Ï???

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2017-4-13 14:28 ½s¿è

ÁÂÁª©¥D«ü¾É¥t¤@±ø«ä¸ô¡I
¥i¯à¬O7#ªº½d¨Ò¥¼¦CÁ|§¹¥þ¡A¦pªG¬O¦a§}¤º®e¦³¡u°Ï1¡v¡B¡u°Ï2¡v¡B¡u¶m1¡v¡B¡u¶m2¡v«hµLªk¦¨¥\¡A½Ð°Ý¸Ó¦p¦ó­×§ï¡H
ªþ¤W¶mÂí¥«°Ï¥N½XÀɮרѰÑ

¶mÂí¥«°Ï¥N½X.zip (13.79 KB)

TOP

¦^´_ 7# p212


§Q¥Î·J¾ãªº¶mÂí¥«°Ï¦WºÙ=LOOKUP(1,0/FIND(K$2:K$375,B3),K$2:K$375)
K$2:K$375¬O¶mÂí¥«°Ï¦WºÙ
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD