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

[µo°Ý] ¸ê®Æ¤ñ¹ï¬Û²Å§ó§ïÃC¦â

[µo°Ý] ¸ê®Æ¤ñ¹ï¬Û²Å§ó§ïÃC¦â

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-1-16 10:06 ½s¿è

·Q½Ð°Ý¦U¦ì¤j¤j~¦]¸ê®Æ¼Æ¾Ú«Ü¦h,¦³¨S¦³¨ç¼Æ¥i¥H±N¤U¦C¸ê®Æ  EÄæ¦ì¦³ÃC¦âªº¼Æ­È ¤ñ¹ïAÄæ¦ì, ¥i¥H¦bµ²ªGÄæ¦ìÅã¥Ü"¦³/µL"¶Ü?

2019-01-15_214858.jpg (50.62 KB)

2019-01-15_214858.jpg

test 0115.rar (7.66 KB)

½d¨Ò

¦^´_ 1# ibmw520


    ¼ÐÃD À³¸Ó§ï¬°µo°Ý ·w

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-1-16 10:05 ½s¿è

B2//°}¦C¤½¦¡:
=IF(COUNT(0/(FIND(LEFT(E$2:E$19,14),"_"&A2)>1)),"¦³","µL")
=IF(COUNT(FIND(LEFT(E$2:E$19&"||",14),A2)),"¦³","µL")

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

ÁÂÁª©¤j¦^´_~
¶W±jªº°Õ~~¥i¥H¥Î¤F~
ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD