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

[µo°Ý] excel ¿é¤JÅçÃÒ°ÝÃD

[µo°Ý] excel ¿é¤JÅçÃÒ°ÝÃD

excel ¿é¤JÅçÃÒ°ÝÃD
·í¿é¤J Lot ID¡G171024¡A¸õ¥X¿ù»~°T®§(¤Ö¤F-05)
·í¿é¤J Lot ID¡G171024-0¡A¸õ¥X¿ù»~°T®§(¤Ö¤F5)·í¿é¤J Lot ID¡G171024-05¡A¥¿½T

·í¿é¤J Lot ID¡G89171128¡A¸õ¥X¿ù»~°T®§(¤Ö¤F-05)
·í¿é¤J Lot ID¡G89171128-0¡A¸õ¥X¿ù»~°T®§(¤Ö¤F2)·í¿é¤J Lot ID¡G89171128-02¡A¥¿½T

²³æ¨Ó»¡: ´N¬O - «e­±¤£ºÞ¡A¥d - ¥[ ¼Æ¦r

00.zip (2.06 KB)

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

TOP

¦^´_ 2# hcm19522

§A¦n,
´ú¸Õ«á¥i¥H¥Î,
¬O§_ÁÙ¥i§Q¥Î ¸ê®Æ -> ÅçÃÒ -> ¦Û­q ³]©w¤½¦¡? ¿ù¤F·|¦Û°Ê¸õ¥X°T®§, µLªk¿é¤J, ÁÂÁÂ
2018-02-09_153010.jpg
2018-2-9 15:30

TOP

(¤è¦¡¤G)=(LEFT(RIGHT(A2,3))<>"-")*(A2>0)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¿ï¾ÜA2:A30
¸ê®Æ - ¸ê®ÆÅçÃÒ - ¸ê®ÆÅçÃÒ - ³]©w / Àx¦s®æ¤º¿ï¾Ü "¦Û­q" / ¤½¦¡¿é¤J ¦p¤U
=COUNT(-RIGHT(A2,3))>0

¥i¥H±±¨î§À½X»Ý¶ñ¤J -01 ~ -99
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# hcm19522

¸Õ¥Î«áOK, ¥i¬O§Æ±æ¯à±q ¸ê®ÆÅçÃÒ ¥h¥d³o­Ó

TOP

¦^´_ 5# ML089

§A¦n,
´ú¸Õ«á¥u¯à²Å¦X¥H¤U
AH17072          -> ¥iª½±µ¿é¤J
AH17072-        -> ·|¸õ¥Xĵ¥Ü°T®§
AH17072-0      -> ·|¸õ¥Xĵ¥Ü°T®§
AH17072-09    -> ¥iª½±µ¿é¤J

­Y·Q­×§ï¬°¥H¤U, »Ý­n¦p¦ó­×§ï, ÁÂÁÂ!
AH17072          -> ·|¸õ¥Xĵ¥Ü°T®§
AH17072-        -> ·|¸õ¥Xĵ¥Ü°T®§
AH17072-0      -> ·|¸õ¥Xĵ¥Ü°T®§
AH17072-09    -> ¥iª½±µ¿é¤J

TOP

¸Õ¸Õ¸ê®ÆÅçÃÒ - ¸ê®ÆÅçÃÒ - ³]©w / Àx¦s®æ¤º¿ï¾Ü "¦Û­q" / ¤½¦¡¿é¤J ¦p¤U
=IF(IFERROR(FIND("-",A1),0),COUNT(-RIGHT(A1,3))>0)

TOP

¦^´_ 8# aer

§A¦n,
·|¥X²{¿ù»~°T®§, ¬O§_¨ó§U½T»{¥i­×§ï!

2018-02-12_162830.jpg
2018-2-12 16:28

TOP

¦^´_ 7# dea172

¤½¦¡§ï¦p¤U¡A½s½X½d³ò -00 ~ -99
=-RIGHT(A2,3)>=0
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD