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

EXCEL ±ø¥ó§PÂ_°ÝÃD

EXCEL ±ø¥ó§PÂ_°ÝÃD

°Ï°ì1
--------------------------------------------
A1 ¦³ J1.80        B1¦³ D35_D99A1
A2 ¦³ J17.80     B2¦³ D35_D99A
A3 ¦³ J27.40     B3 ¦³ D40A1   

°Ï°ì2
---------------------------------------------------
D1 ¦³  J1.80            E1   ¦³  D35A1
D2 ¦³  J17.80          E2  ¦³  D99A1

¦p¦óÅý °Ï°ì2 ¥h¬d§ä °Ï°ì1  ¦pªG§ä¨ì35 ©Î¬O 99 ¨ä¤¤¤@­Ó´N§P©wOK

°²³]¥HD1Àx¦s®æ¦Ó¨¥     ¦pªG§ä¨ì35 ©Î¬O 99 ¨ä¤¤¤@­Ó´N§P©wOK
¥Ø«e §Ú¥ÎVLOOKUP ¤U¥h¬d§äJ1.80     ¦ý¬OÅܦ¨­n§¹¥þ¤@¼Ë35 99­^¤å®a¼Æ¦r³£­n¤@¼Ë

³Â·Ð½Ð«ü±Ð¤@¤U ·PÁÂ

=IF(COUNTIF(B1:B3,"*"&A7&"*")>0,"OK","")

A7¿é¤J 35 ©Î 99

TOP

¥»©«³Ì«á¥Ñ iwiniwin ©ó 2014-2-20 15:49 ½s¿è

·PÁ¦^µª §Ú§Æ±æ¬Ý¯à¤£¿é¤J¼Æ¦r¶Ü  ¦]¬°¬O¾ã­Ó¸ê®Æ®w ¥i¯àÁÙ¦³«Ü¦h¹³¬O44 45 ­n¤ñ¨ä¤¤¤@­Ó¦³´N§P©wOK

¹³§Aªº¼gªkªº¸Ü·|Åܦ¨ ¥ô¦ó¼Æ¦r¤j©ó0³£·|§P©w OK

TOP

¦^´_ 3# iwiniwin


    ¦Û´ú¸Õ¹L, ¿é¤J¤¤­^¼Æ³£¥i¥H.

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD