ªð¦^¦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

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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD