¤j¤j̦n,
½Ð°Ý¥H¤U°ÝÃD
CÄæ·|¦³ª«¬y°Óªº¦W¦r,¥Ø«e¤wª¾ ¥x¤¤.ªá½¬.°ª¶¯.¶³ªL,¬O§Ú¤£nªº¸ê®Æ,¦ýì¸ê®Æn«O¯d,
§Ú¨Ì¾ÚCÄ檫¬y°Ó,¦bKÄæshow¥X§Únªºª«¬y°Ó²ºÙ,§Únªº§@¥Î¬O:
CÄæ¤@¥X²{§Únªºª«¬y°Ó,´N¨Ì§ÇÅã¥Ü,¤@ª½¨ì¤U¤@ÓCÄæ¥X²{·sªºª«¬y°Ó,¦pªG¬O§Únªº´NÅã¥Ü·sªº,
¬On±Æ°£ªº,´N¥X²{ERR,¤@ª½¨ì¸ê®Æªº³Ì©³ºÝ,¦ý²{¦b¦³Ó°ÝÃDµLªk¸Ñ¨M,¦³´XӮƸ¹¤£¬O§Únªº,
§Æ±æ¥¦¤]¥i¥H±Nª«¬y°ÓÅã¥Ü¬°ERR,§Ú±N»Ýn±Æ°£ªº°Ó«~¶K¦bO1:P8
¥Ø«e§Ú¥Î¨ç¼ÆK2=IF(COUNTIF(C2,"¥x¤¤*")+COUNTIF(C2,"ªá½¬*")+COUNTIF(C2,"°ª¶¯*")+COUNTIF(C2,"¶³ªL*")=1,"ERR",IF(COUNTIF(C2,"ªL¤f*"),"¤ñµá¦h.ªL¤f¥þ¥x",IF(COUNTIF(C2,"¤K¼w*"),"¤ñµá¦h.¤K¼w¥þ¥x",IF(COUNTIF(C2,"¤j·Ë*"),"¤ñµá¦h.¤j·Ë¥þ¥x",K1))))
¥¦¥i¥H¥X²{§Únªºª«¬y°Ó²ºÙ,¦ýµLªk±Æ°£¤£nªº®Æ¸¹,±Nª«¬y°ÓÅܬ°ERR,½Ð°Ý¨ç¼Æ¥i¥H¦p¦óקï?
¸ê®Æ±Æ°£°ÝÃD.rar (29.9 KB)
|