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

[µo°Ý] ¦r¦êªº¤ñ¸û

[µo°Ý] ¦r¦êªº¤ñ¸û

¥­¦w
¨â­Ó¬Ý°_¨Ó§¹¥þ¬Û¦Pªº¦r¦ê , ¬°¤°»ò¤£¦P©O ?
¦p¦óÅýExcel¦³´¼¼z©O ?
¦b¤ñ¸ûªº®É­ÔÅã¥Ü¬Û¦P©O ?

¦r¦ê¤ñ¸û.rar (6.32 KB)

Áo©úªº¤ñ¸û

µL¤îºÉªº§V¤O¤W¶i

=IF(SUBSTITUTE(A2,CHAR(13),"")=SUBSTITUTE(B2,CHAR(13),""),"¬Û¦P", "¤£¬Û¦P")
¥@¬É¨º»ò¤j¡A¥i§Ú·Q¥h­þ¡H

TOP

=IF(CLEAN(A2)=CLEAN(B2),"¬Û¦P", "¤£¬Û¦P")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089

¯u¥O¤H¿³¾Ä
·PÁ¦³±z
µL¤îºÉªº§V¤O¤W¶i

TOP

¦^´_ 2# Joforn

³o¬O¤@­Ó¦n¤èªk
ÁÂÁ±z
µL¤îºÉªº§V¤O¤W¶i

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD