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

[µo°Ý] ½Ð°Ý­pºâ¤£­«½Æ¼Æ¥Øªº¨ç¼Æ, ÁÂÁÂ

[µo°Ý] ½Ð°Ý­pºâ¤£­«½Æ¼Æ¥Øªº¨ç¼Æ, ÁÂÁÂ

¨Ï¥ÎCOUNT ·f°t FREQNENCY ¨Ó­pºâ¤@²Õ¼Æ¦r¸ê®Æ¡A¨ä¦@¦³´XºØ¤£­«½Æ¼Æ¦r
¨ä¨ç¼Æ¬° =COUNT(1/FREQUENCY(A1:C3,A1:C3))

¦pªG­n¿z¥X¤j©ó100ªº
¨ä¨ç¼Æ¬° {=COUNT(1/FREQUENCY(IF(A1:C3>=100,A1:C3),A1:C3))}

½Ð°Ý¦pªG§Ú­nºâªº¬O¤¶©ó50¦Ü99¶¡ªº
¨ä¨ç¼Æ¸Ó¦p¦ó¼g


ÁÂÁÂ
½d¥».zip (7.18 KB)

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