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

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

¦^´_  kaigan89
Hsieh µoªí©ó 2010-9-22 23:12



    ÁÂÁ¶W¯Åª©¥D¼ö¤ß¶K¹Ï¡I
¥i±¤¹Ï©ñ¤j¤§«áÁÙ¬O¤£²M·¡
¥u¯à¥b²q¥b´ú
ÁÙ¬O¨S¾Ç·|¡I¥i±¤¤F¤@¦¸¦nÃD§÷

TOP

¦^´_ 1# leiru

¦pªG³o¼Ë¤l©O??
¿ß¥£¤@ªT ^_^

TOP

¦^´_ 12# kaigan89


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

TOP

¥»©«³Ì«á¥Ñ Luna ©ó 2010-9-28 13:39 ½s¿è

¦^´_ 1# leiru

¤£ª¾«ç¦b¦P¤@®æÅã¥Ü©Ò¥H......§Ú¥u·|¤g¤èªk....©Ò¥H©O~~
   
¤g¤èªk¦A¤@  :

=IF((A3=B3)*(A3=""),"AB³£¨S¦³",IF((A3=B3),"AB¬Û¦P"&A3,IF((B3>A3>B3)*(A3=""),"¬Û²§B="&B3&","&"A¨S¦³",IF((A3>B3>A3)*(B3=""),"¬Û²§A="&A3&","&"B¨S¦³","¬Û²§ A"&B3&","&"B"&A3))))

¿ß¥£¤@ªT ^_^

TOP

²Â¤èªk¦ý§Ú±`¥Îªº´£¨Ñ°Ñ¦Ò
1.±Na,b¤GÄæ¦X¨Ö¶Kc,
2.d=countif(c$1:c1,c1)=1(¿z¿ï1¨ú¤£­«ÂЭÈ),
3.e=countif(a:a,c1)=0(aÄæ¨S¦³ªº)
4.f=countif(b:b,c1)=0(bÄæ¨S¦³ªº)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_  leiru

¦pªG³o¼Ë¤l©O??
Luna µoªí©ó 2010-9-24 14:57



    ÁÂÁÂleiru¶K¹Ï
³o¼Ë´N¬Ý±o²M·¡¤F¡I¤]¬ÝÀ´¤F¡I

TOP

¥»©«³Ì«á¥Ñ kaigan89 ©ó 2010-9-27 08:46 ½s¿è
¦^´_  kaigan89
Hsieh µoªí©ó 2010-9-24 15:08



    ÁÂÁª©¤j¼ö¤ß¶K¹Ï¡A³o¦^¬Ý²M·¡¤F¡I
½Ð°Ý¡G
¿z¿ï·Ç«h$A$1A$2¡A¦ýA1¬OªÅ¥Õªº¡A¥Nªí¤°»ò·N«ä¡H¬°¤°»ò¥i¥H¬OªÅ¥Õªº¡H
´ú¸Õ¤@¤U¡A¿z¿ï±o¨ìªºµ²ªG¬OA ¡A³oµ²ªG¬O¤°»ò·N«ä¡H½Ð«ü±ÐÁÂÁÂ

TOP

¦^´_ 17# kaigan89

EXCEL»¡©ú¦p¤U

±N¤½¦¡µ²ªG¥Î§@±ø¥ó
±z¥i¥H±N¤½¦¡ªº­pºâµ²ªG§@¬°·Ç«h¨Ï¥Î¡C¦b¨Ï¥Î¤½¦¡«Ø¥ß·Ç«h®É¡A½Ð¤£­n±NÄæ¼ÐÅÒ§@¬°·Ç«h¼ÐÅҨϥΡA¦ÓÀ³¸Ó±N·Ç«h¼ÐÅÒ¯dªÅ¥Õ¡A©Î¨Ï¥Î½d³ò¤¤¤£¬OÄæ¼ÐÅÒªº¼ÐÅÒ¡C

³o´NÃþ¦üsqlÂ^¨ú­pºâµ²ªG¸ê®Æ°µ¬°·s¼ÐÅÒÄæ¦ì
¯dªÅ¥Õ¼ÐÅÒ«h·|¦Û°Ê¥H¿z¿ïÄæ¦ì¼ÐÅÒ°µ¬°·s¼ÐÅÒ
­«­nªº¬O¤½¦¡¥H¤W¦¸¹Ï¥Üªºh2¤½¦¡
=COUNTIF($B$1:$B$335,A2)>0
³o­Y¬O¦b¤@¯ë¤½¦¡³Q¸ÑŪ¦¨
bÄ椤µ¥©óa2ªº¼Æ¶q
excel«ÜÁo©ú·|¦Û°Ê§âaÄæ©Ò¦³­È¥h°µ­pºâ
¥u­naÄ椤ªº­È¦bbÄd¤¤ªº¼Æ¶q¤j©ó0
´N¬O²Å¦X±ø¥ó´N·|³Q¿z¿ï¥X¨Ó
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-9-27 15:13 ½s¿è



·PÁ¶W¯Åª©¤j¸Ô²Ó¸Ñ»¡¡I
§Ú¦Û¦æ»s§@¤@Àɸէ@
µ²ªG¬Û¦Pªº¸ê®ÆÄæ¦ìÁÙ¬O³Q¿z¿ï¥X¨Ó¦p¹Ï
¤£ª¾°ÝÃD¦ó¦b¡H
=COUNTIF($A$1:$A$365,A2)>0 ¨ä¤¤²Ä¤G¤Þ¼ÆA2¬O³æ«üA2¶Ü¡H
ÁÙ¬O¥t¦³¥Î·N¡H

TOP

=COUNTIF($A$1:$A$365,A2)>0
³o¼Ëa2:a365¨C­Ó­È³£·|²Å¦X±ø¥ó
³o¸ò§A¶K¹Ï¤S¤£¤@¼Ë
=COUNTIF($B$2:$B$74,A2)>0
¤½¦¡·N¸q¬OBÄ椤­pºâAÄd­Èªº­Ó¼Æ¤j©ó0
¤]´N¬O¦bBÄæ¤]¦P®É¥X²{ªºAÄ檺­È
¦Ó§A¬O°w¹ïAÄæ°µ¿z¿ï
¨º´N¬OA¸òB¦P®É¥X²{ªº­È
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD