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

[µo°Ý] ½Ð°ÝMID¨ç¼Æ­n¥[¦b­þ?

[µo°Ý] ½Ð°ÝMID¨ç¼Æ­n¥[¦b­þ?

½Ð°Ý¦U¦ì¤j¤j
§ÚªºÀx¦s®æ¤½¦¡¦p¤U,¦]¬°·QÅã¥Ü¨ä¤¤ªº1~6­Ó¦r,©Ò¥H·Q¥ÎMID¨ç¼Æ¨ÓÅã¥Ü,¦ý¸Õ¹L¦h­Ó¦ì¸m³£µLªkÅã¥Ü,
©Ò¥H·Q½Ð°Ý³o­ÓMID¨ç¼Æ­n©ñ¦b­þ­Ó¦ì¸m¤~¬O¥¿½Tªº?
©Î¬O¦³¨ä¥L¨ç¼Æ¥i¨ú¥N¨Ï¥Î,ÁÂÁÂ

IFNA(CONCATENATE(FILTER('ªí³æ¦^À³ 1'!$U:$U,('ªí³æ¦^À³ 1'!$C:$C=A2)*('ªí³æ¦^À³ 1'!$D:$D=$F$1)*('ªí³æ¦^À³ 1'!$E:$E='²M³æ'!$D$15))),"")

©ñ¦b¥H¤U³o­Ó¦ì¸m«hÅã¥Ü#ERROR!
IFNA(MID(CONCATENATE(FILTER(F12,1,6,('ªí³æ¦^À³ 1'!$U:$U,('ªí³æ¦^À³ 1'!$C:$C=A12)*('ªí³æ¦^À³ 1'!$D:$D=$F$1)*('ªí³æ¦^À³ 1'!$E:$E='²M³æ'!$D$15)),""))))

¥»©«³Ì«á¥Ñ luhpro ©ó 2024-10-25 00:25 ½s¿è

¦^´_ 1# lky12345
¦]¬°§A¨S¦³µ¹½d¨Òµ{¦¡, ¨ü­­©ó®É¶¡¤£¤Ó°÷, ©Ò¥H§Ú¥u¯àÁ|¨Òµ¹§A°Ñ¦Ò¬Ý¬Ý:

MID¨ç¼Æ ªº¥Îªk¦p¤U :

MID(¤å¦r¦ê¦WºÙ, °_©l¦ì¸m, §ì¨úªº¤å¦r­Ó¼Æ)

°²³]¤@­Ó¤å¦r¦ê : sStr = "w30amkra-03rtkq-"
­Y·Q§ì¨ú²Ä1­Ó¦r¤¸°_ºâ6­Ó¤å¦r,
¥i¨Ï¥Î : sTar = MID(sStr, 1, 6) (¨ä¹ê­Y¬O±q¶}ÀY°_ºâ®É, ¥i¥H¥Î LEFT(sStr, 6) §Y¥i)
«h sTar = "w30amk"
ÃöÁä¬O§Aªº¨º¦ê«ü¥O¬O­n©ñ¦b¤W¦¡¤¤ªº sStr  ªº¦ì¸m.

TOP

¦^´_ 2# luhpro
·PÁ¤j¤jªº«ü¾É,ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD