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

Ãö©óEXCEL ¤ñ¸û¼Æ¦r°ÝÃD

Ãö©óEXCEL ¤ñ¸û¼Æ¦r°ÝÃD

§Ú¦³¤@­Ó ­È   PPS65_97     ¥t¤@­Ó PS65PS97  §Ú·Q§â³o2­Ó­È°µ¤@­Ó¤ñ¸û

¦³¿ìªk°µ 65 97  ¦³¦P®É¥X²{³o­Ó¼Æ¦r  ¦Û°Êµ{¦¡§P©w OK   ¨S¦³¥X²{ 65 97  ´N¥¢±Ñ


½Ð¨D«ü¾É

¦^´_ 1# iwiniwin

°²³] A1=PPS65_97,A2=PS65PS97

¤½¦¡ =IF(AND(IF(ISERROR(SEARCH("*65*97",A1,1)),0,SEARCH("*65*97",A1,1))=1,IF(ISERROR(SEARCH("*65*97",A2,1)),0,SEARCH("*65*97",A2,1))=1),"OK","¥¢±Ñ")

TOP

½Ð°Ý¤@¤U ¦b¤u¦¡65* 97 ³o­Ó³¡¤À¥i¥HÅܦ¨¥u§ìÅܼƼƦr¶Ü?
¦]¬°ÁÙ¦³  PPS1_33     ¥t¤@­Ó PS1PS33
¤@¼Ë°²³] §Ú­nÅý¥L¤ñ¹ï ¥L¼Æ¦r¥i¯à¤£¤Ó¤@¼Ë  ¦³¿ìªk¤@­Ó¤½¦¡¦Y¥þ³¡¶Ü?
§Ú·QÅý¥L¥u§ì¨ú 1 33 ¸ò¥t¤@­Ó¤]§ì 1 33 ¤ñ¹ï  
·PÁ¦^µª

TOP

§Ú³oÃ䶶«K§â¤½¦¡¥H§ÚÆ[ÂI»¡©ú¤@¤U  2F ­ì©l¼gªº¤½¦¡
¬OÅý A1 65*97µ¥©ó1  µM«á¦A¥h§äA2 65*97µ¥©ó1  ¦A§â2­Ó¤ñ¸û
³£¤@¼Ë´N¦¨¥\

TOP

¬ã¨s¦¨¥\ µ²ªG¦p¤U  ¤@­Ó¦bO4  ¤@­Ó¦bM4   2­Ó¤ñ¸û¦¨¥\OK ¥¢±Ñ NG
IF(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(M4,"PS",""),"P",""),"_","")=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(O4,"PS",""),"P",""),"_",""),"OK","NG")

TOP

¥Ø«e¦³­Ó·s°ÝÃD·|³Â·Ð«ü¾É¤@¤U

A1 ¦³ NG  
A2 ¦³ OK         ¥Ø«e A3³o­Ó¦ì¸m ­n§ì¨ú«e­±ª½§ì¨ì¬ONGÅã¥Ü ªÅ¥Õ  §ì¨ì OK ªº¸Ü
                            §Ú·Q­n°õ¦æ¬Y­Ó¨ç¼Æ
                                      =(VLOOKUP((MID(L4,6,3)),$B$4G$199,5,FALSE))&                 
                                       (VLOOKUP((MID(L4,6,3)),$B$4G$199,6,FALSE))


¦p¦ó¥i¥H¼g¤@°_

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD