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

[µo°Ý] ¦p¦ó¨ú¨C¤ë³Ì«á¦¬½L¤é

[µo°Ý] ¦p¦ó¨ú¨C¤ë³Ì«á¦¬½L¤é

½Ð±Ð¦U¦ì°ª¤â¡AÀɮפ¤AÄæ¬Oªñ3.5¦~¦¬½L¤é´Á¡A§Ú¦bNÄæ§Q¥Î¤½¦¡¨ú¨C¤ë³Ì«á¤@­Ó¤u§@¤Ñ¡AÀ³¸Ó¤½¦¡¦³»~¡A¦³¨Ç¨Ã¤£¬OAÄæ¸Ó¤ëªº³Ì«á¤@¤Ñ(¦¬½L¤é)¡A¦pOÄ椤¦³¶À¦â©³¦âªº¤é´Á¦bAÄ椤¨Ã¤£¦s¦b¡A½Ð±Ð¦U¦ì°ª¤â­n¦p¦ó¦bNÄ椤¨ú¥XAÄ椤¨C¤ëªº³Ì«á¤@¤é¡AÁÂÁ¡C t.rar (84.38 KB)
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

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

TOP

¦^´_ 2# hcm19522

ÁÂÁ±z¡A±zªº¤è¦¡»P§Ú¬Û¦P¬O¨ú¤ë¾ä¤Ñªº³Ì«á¤@¤Ñ¡AµLªk¨ú¥XBÄæ©Ò¦Cªº·í¤ë³Ì«á¤@¤Ñ
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

¦^´_ 3# bhsm

¨Ì§A¼Æ¾Ú =IF(TEXT(A6,"EM")=TEXT(A5,"EM"),"",A6)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522
·PÁÂhcm19522¤j,±z¯u¬O¤Ó¯«¤F
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD