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

¤À²Õ±Æ§Ç

¦^´_  chin15

­Y¦³¸s²Õ±Æ¦C¸Õ¸Õ¬Ý
Hsieh µoªí©ó 2012-9-8 01:48


½Ð±Ð¶Wª©¤j:
    SUMPRODUCT((a>C2)*(COUNTIF(a,a)>1))/2
¬õ¦â¦rÅé§Ú¤£¤Ó©ú¼I,§Ú¬Ýaªº¦WºÙµ¥©óÁ`¤Àªº¼Æ­È,"a>c2"³oÅÞ¿è³£¬Ofalse,"countif(a,a)>1"¤]³£µ¥©ófalse.
©Ò¥Hsumproduct(false*false)/2=0,¥i¥H½Ð¶Wª©¤j¸ÑÄÀ¤@¤U¶Ü¡H³o­Ó¦a¤è§Ú­þ¸Ì§PÂ_¿ù»~¡HÁÂÁ¡I
¥Î²³æªº¤ß°µ½ÆÂøªº¨Æ

TOP

¦^´_ 11# BigDog
©w¸q¦WºÙa¬O¨ú±o¨C¯ZªºÁ`¤À½d³ò
SUMPRODUCT((a>C2)*(COUNTIF(a,a)>1))
¥H¤@¦~¤@¯Z¬°¨Ò¡Aaªº½d³ò¬OC2:C4
a>C2´ú¸Õ¨C­ÓÁ`¤À¤ñC2¤jªº¼Æ¦³C3¡BC4
©Ò¥H±o¨ì¤@­Ó°}¦C{TRUE,FALSE,FALSE}
COUNTIF(a,a)>1«h¬O­pºâa½d³ò¤º¨C­Ó¼Æ値¥X²{¦¸¼Æ
±o¨ì°}¦C{1,1,1}>1´N¦¨¤F{FALSE,FALSE,FALSE}
SUMPRODUCT({TRUE,FALSE,FALSE}*{FALSE,FALSE,FALSE})
´N¦¨¤FTRUE*FALSE+FALSE*FALSE+FALSE*FALSE
=0+0+0
=0
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  BigDog
©w¸q¦WºÙa¬O¨ú±o¨C¯ZªºÁ`¤À½d³ò
SUMPRODUCT((a>C2)*(COUNTIF(a,a)>1))
¥H¤@¦~¤@¯Z¬°¨Ò¡Aa ...
Hsieh µoªí©ó 2012-11-27 21:44


©çÁÂ,¦A¦¸½Ð±Ð¶Wª©¤j,
°ÝÃD¤@:
¥H¤@¦~¤@¯Z¬°¨Ò¡Aaªº½d³ò¬OC2:C4, a>C2´ú¸Õ¨C­ÓÁ`¤À¤ñC2¤jªº¼Æ¦³C3¡BC4.
¥H¤@¦~¤T¯Z¬°¨Ò¡Aaªº½d³ò¬OC9:C13, a>C9¨S¥b­Ó,¨º¤½¦¡´N³£¦¨¬°false,³o¸Ì§ÚªºÆ[©À­þ¸Ì¦³°ÝÃD¡H
°ÝÃD¤G:
¹ÏÀÉÂŦâ¦rÅ骺¤½¦¡ÀHµÛÀx¦s®æ¦Ó§ïÅÜ,¨º¤½¦¡´N·|¤@ª½¤£¦¨¥ß?

ÁÂÁÂ!!
¥Î²³æªº¤ß°µ½ÆÂøªº¨Æ

TOP

¦^´_ 13# BigDog


    ¨S¿ù°Ú!
³o¬O­n¥[¶i¨Ó¤ñCÄæ¤jªº¼Æ値­Ó¼Æ¡AC9¬OC9:C13¤¤³Ì¤j­È
©Ò¥H¡A±N¤º«ØRANK¨ç¼Æ¨ú±oªº±Æ¦W´î¥h¤ñ¸Ó¦CCÄæ¤jªº­Ó¼Æ´N¬O¥¿½T¤£­«½Æ±Æ¦W
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 14# Hsieh


    ¸ê½è¶w®©,·PÁ¦^µª. ^^"
¥Î²³æªº¤ß°µ½ÆÂøªº¨Æ

TOP

¦^´_ 14# Hsieh

½Ð°Ý¶Wª©¤j
    (C2:C18<=TRANSPOSE(C2:C18)  => ³o¤½¦¡¤£¬O¥þ³£TRUE¶Ü¡H ¤£¬O«ÜÀ´,¬°¤°»ò¦³¨Ç·|ÅÜFALSE.
    (A2:A18=TRANSPOSE(A2:A18)     => ³o¤½¦¡¤£¬O¥þ³£TRUE¶Ü¡H ¤£¬O«ÜÀ´,¬°¤°»ò¦³¨Ç·|ÅÜFALSE.


   

ÁÂÁ¶Wª©¤j.
¥Î²³æªº¤ß°µ½ÆÂøªº¨Æ

TOP

¦^´_ 1# chin15


    chin15¤j¤j±z¦n:
                          ¯à§_À°§Ú¸ÑÄÀ16fªº°ÝÃD¶Ü¡HÁÂÁÂ!!
¥Î²³æªº¤ß°µ½ÆÂøªº¨Æ

TOP

¦^´_  chin15


    chin15¤j¤j±z¦n:
                          ¯à§_À°§Ú¸ÑÄÀ16fªº°ÝÃD¶Ü¡HÁÂÁÂ!!
BigDog µoªí©ó 2012-12-3 23:19



    ¤w¸g¬ÝÀ´¤F@@"
ªá¤F¤@¾ã¤Ñªº®É¶¡,¦ý­n¹ê»Ú¹B¥ÎÁÙ¯u¦³¨Ç§xÃø,­n¦h¦h½m²ß,ÁÂÁ¦U¦ìªº¸Ñ»¡....
¥Î²³æªº¤ß°µ½ÆÂøªº¨Æ

TOP

ÁÂÁª©¥D¾A®É¸Ñ¨M§ÚªººÃ°Ý

TOP

¦¨¥ß»P¤£¦¨¥ß¥i¥H¦^¶Ç¦¨¤å¦r©Î¼Æ­È
³o¼Ë±o¥Xªº¸ê®Æ¡A¤§«áÁÙ¯à°÷®M¤J¨ä¥LªºªF¦è

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD