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

[µo°Ý] ½Ð°Ý¦U¦ì¥ý¶i¤@­Ó°ÝÃD

[µo°Ý] ½Ð°Ý¦U¦ì¥ý¶i¤@­Ó°ÝÃD

¦U¦ì¥ý¶i¡G
                      ¦¹Àɦ³¿ëªk±N2ºØ¤£¦P¦W«~¥h°µ¬d¸ß¶Ü¡HA¡BBÄæ¬°¬d¸ß¸ê®Æ¡ACÄæ¬°³Q±a¥X¸ê®Æ¡AEÄæ¬°¿é¤J¬d¸ß¸ê®Æ¡ADÄæ¬°¬O§_¥¿½T¡AFÄæ¬°±a¥X¬d¸ß¸ê®Æ«á±a¥XCÄæ¤º¸ê®Æ¡A³o­Ó·Q¦n¤[¡A¤p§Ì¥u¯à°µ¦¨¤GÄæªº¿é¤J¬d¸ß¡A¬O§_¦³¿ëªk¥u»Ý¤@Äæ¿é¤J¬d¸ß´N¯à§¹¦¨©O¡H

¼Ë«~¹Ï.jpg (64.05 KB)

¼Ë«~¹Ï

¼Ë«~¹Ï.jpg

¼Ë«~.rar (7.5 KB)

¼Ë«~ÀÉ

¦^´_ 1# spensers

1] ¤w¸Ë½c¤ÀÃþ½T»{Äæ¡AF2¿é¤J¤½¦¡«á¡A¦V¤U½Æ»s :

=IF(E2="","",IFERROR(LOOKUP(9^9,FIND(E2,A$2:A$18&B$2:B$18),C$2:C$18),"NG"))


2] ¬O§_¤w¸Ë½c½T»{Äæ¡AD2¿é¤J¤½¦¡«á¡A¦V¤U½Æ»s :

=IF(E2="","",IF(N(F2),"OK","NG"))

TOP

¦^´_ 2# JBY


    ·PÁÂ¥ý¶i¡A§Ú¤S¦h¾Ç¤@¨Ç¤F¡C

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD