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

¤ñ¹ï¨Ã§PÂ_Åã¥Ü°T®§°ÝÃD

http://blog.xuite.net/hcm19522/twblog/482139178

TOP

¦^´_ 5# ML089


±z¦n,¥i¥H±Ð§Ú¤@¤U
LOOKUP(,0/(LEFT(B3,{9,13,14})=LEFT(H3,{9,13,14})),{"§ó§ï®Æ¸¹","ª©¥»¤É¯Å",""}
¥Îªk¤Î·N«ä¶Ü
Just do it.

TOP

¦^´_ 5# ML089

½Ð°Ý --> (LEFT(B3,{9,13,14}) ³o¬qªº·N«ä¬O?
¥t¥~ { } ³o¬O¥Nªí?
Just do it.

TOP

¦A²¤Æ

=IF(COUNTA(B3,H3)=1,IF(B3="","·s¼W®Æ¥ó","§R°£®Æ¥ó"),LOOKUP(,0/(LEFT(B3,{9,13,14})=LEFT(H3,{9,13,14})),{"§ó§ï®Æ¸¹","ª©¥»¤É¯Å",""}))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# jsc0518

¦b²¤Æ¤@¤U¤½¦¡
=IF(AND(B3="",H3<>""),"·s¼W®Æ¥ó",IF(AND(B3<>"",H3=""),"§R°£®Æ¥ó",LOOKUP(,0/(LEFT(B3,{9,13,14})=LEFT(H3,{9,13,14})),{"§ó§ï®Æ¸¹","ª©¥»¤É¯Å",""})))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089


    ML089¡A·PÁ±z´£¨Ñªº¤½¦¡¡A§Ú·|¦n¦n¾Ç²ß¡CÁÂÁÂ!
Just do it.

TOP

¦^´_ 1# jsc0518
=IF(B3=H3,"",IF(AND(B3="",H3<>""),"·s¼W®Æ¥ó",IF(AND(B3<>"",H3=""),"§R°£®Æ¥ó",IF(AND(LEFT(B3,13)=LEFT(H3,13),RIGHT(B3,1)<>RIGHT(H3,1)),"ª©¥»¤É¯Å",IF(AND(LEFT(B3,9)=LEFT(H3,9),RIGHT(B3,5)<>RIGHT(H3,5)),"§ó§ï®Æ¸¹","?")))))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD