ªð¦^¦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 : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD