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

¤ñ¹ï¨âÄæ¸ê®Æ¡A¦C¥X¬Û¦P¤Î¤£¬Û¦Pªº­È

¤ñ¹ï¨âÄæ¸ê®Æ¡A¦C¥X¬Û¦P¤Î¤£¬Û¦Pªº­È

½Ð°Ý¦p¦ó¤ñ¹ï¨âÄæ¸ê®Æ,¦P®É¤S¦C¥X¬Û¦P¤Î¤£¦Pªº¸ê®Æ

¤ñ¹ï¸ê®Æ.JPG (43.07 KB)

¤ñ¹ï¸ê®Æ.JPG

joyce

¦^´_ 1# leiru


   ¸Õ¸Õ¬Ý
¤ñ¹ï3.rar (12.59 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂHsiehª©¥D¦^ÂÐ.
joyce

TOP

¦^´_ 4# kaigan89


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­É¥Î¤@¤UÁÂ¥Sªº¤å¥ó¡C
°}¦C¤½¦¡¦b§C¶¥ªº¹q¸£¦p§Úªº¹q¸£¶}±ÒÀÉ®×´N­n¤@¬q®É¶¡¡A¤£§«°Ñ¦Ò¤@¤U¶i¶¥¿z¿ï¡C


    ¤ñ¹ï3.rar (8.48 KB)

TOP

A and B
IF(ROW(1:26)>COUNT(MATCH(A2:A27,B2:B27,)),"",SMALL(IF(A2:A27*ISNUMBER(MATCH(A2:A27,B2:B27,)),A2:A27,""),ROW(1:26)))

only A
IF(ROW(1:26)>(COUNT(A2:A27)-COUNT(MATCH(A2:A27,B2:B27,))),"",SMALL(IF(A2:A27*ISNA(MATCH(A2:A27,B2:B27,)),A2:A27,""),ROW(1:26)))

only B
IF(ROW(1:26)>(COUNT(B2:B27)-COUNT(MATCH(B2:B27,A2:A27,))),"",SMALL(IF(B2:B27*ISNA(MATCH(B2:B27,A2:A$27,)),B2:B27,""),ROW(1:26)))

³£¬O°}¦C¤½¦¡¡A°Ñ¦Ò¡A½Ð«ü±Ð..

TOP

¦^´_ 4# Hsieh


¬ã¨s¤F¤@¤Uª©¥Dªº¤½¦¡¡AªGµM²¼ä¦h¤F¡I¨ØªA..
ÁÙ¦³ºÃ°Ý­n½Ð±Ð¤@¤U¡G
¤½¦¡¤¤ROW(A1)*2   ===> ¬°¤°»ò­n­¼2¡H¡H
¨Ì¼Ëµe¸¬Äª¸Õ¸Õ¡Aµ²ªG¥X²{³o¼Ëªº²Å¸¹ #NUM!  ¡A¤£ª¾¹D§Ú¬O­þ¸Ì§Ë¿ù¤F¡H..

TOP

¦^´_ 7# toomellowhaw
¦]¬°ab¦P®É¦s¦b©Ò¥H¼Æ¶q¥u³Ñ¤@¥b
­Y¬Oa¸òb¬Û¦P·|¦³2­Ó¥H¤W´N·|¥X¿ù
©Ò¥HÁÙ¬O¶i¶¥¿z¿ï¨Óªº¹ê¥Î
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh


­ì¨Ó¦p¦¹¡A·PÁ¸ѻ¡..

¦A¨Ó¦n¦n¬ã¨s¤@¤U¶i¶¥¿z¿ï..

TOP

ª©¥D¡A¦]¬°§Ú¤£¯à¤U¸üÀɮסA¥i§_¦C¥X¤½¦¡¨Ó¬Ý¬Ý¬O«ç¼Ë°µ¡H
IRENE

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD