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

½Ð°Ýcountif¦³¿ìªk°µ¨ì¶Ü? - 2

½Ð°Ýcountif¦³¿ìªk°µ¨ì¶Ü? - 2

½Ð°Ýcountif¦³¿ìªk§@¨ì,
¦pªí®æ¤º¬õ¦â®Ø®Øªºµ²ªG¶Ü?
countif-2.JPG
2013-1-5 11:43

¥Î¼Ï¯Ã©Ô¤@¤UÀ³¸Ó§Y¥i¡C
¤£¹L­n¬Ý§A¥Øªº¬O¤°»ò¡C¦pªG¥u­n¼Æ¦rªº¸Ü¡C

TOP

¦^´_ 2# Baracuda


    ÁÂÁ±zªº¦^ÂÐ,§Ú¬O·Q­n¥Î¨ç¼Æ¤½¦¡,µM«á¨Ï¥Î¥¨¶°°õ¦æ¤£¦Psheet^^

TOP

¦^´_ 3# alltest

=IF(COUNTIF(A2:$A$65535,A1)=0,COUNTIF(A:A,A1),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ÁÂÁÂHsieh ¶W¯Åª©¥D±zªº¦^ÂÐ~
     ¤£¦n·N«ä,®e§Ú»¡©ú¤@¤U
    ¬õ¦â®Ø®Øªºµ²ªG¬O®Ú¾ÚAÄæ¦ì,«e¨â¦ì¼Æ¦r©Ò±oªºµ²ªG
    ¤£¾å±ocountif¥i¥H¥u°w¹ïÀx¦s®æ¤å¦rªº«e¨â¦ì§@­pºâ¶Ü?
     ½Ð°Ý¶W¯Åª©¥D¤j¤j¨ç¼Æ¤½¦¡¸Ó¦p¦ó¼g¤~¦n©O?

    =IF(COUNTIF(A2:$A$65535,A1)=0,COUNTIF(A:A,A1),"")
   °õ¦æµ²ªG(ÂŦâ®Ø®Ø)
   
countif-2-1.JPG
2013-1-6 07:45

TOP

¦^´_ 5# alltest


    =IF(COUNTIF($A2:$A$1048576,LEFT(A1,2)&"*")=0,COUNTIF(A:A,LEFT(A1,2)&"*"),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


    ÁÂÁ±z~ Hsieh ¶W¯Åª©¥D¤j¤jªº¼ö¤ßÀ°¦£­×§ï¨ç¼Æ¤½¦¡^^
   ¤w¸g°õ¦æ¦¨¥\¤F~·P®¦
  ¤½¦¡¬Ý°_¨Ó«Ü½ÆÂø,¹ï©óªì¾Çªº§Ú
  ¯u¬O¦³¬Ý¨S¦³À´
  ¯uªº­nªá®É¶¡¦n¦n²z¸Ñ¤F

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD