ªð¦^¦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)

¦^´_ 1# cksmark129


    =COUNT(1/FREQUENCY(IF((A1:C3>=50)*(A1:C3<=99),A1:C3),A1:C3))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

½Ð°Ý¤½¦¡¤¤ COUNT ¥Î 1¥h°£ ¥Nªíªº§t·N¬O¬Æ»ò¡H
  =COUNT(1/FREQUENCY(A1:C3,A1:C3))

¤£¦n·N«ä¡A¤£¤Ó²z¸Ñ¡A½Ð¥ý¶i­Ì¯à°÷«üÂI¤@¤U¡AÁÂÁÂ

TOP

¦^´_ 3# jsleee


1/0 ·|Åܦ¨¿ù»~­È,
=1/{1;0;0;4;2}  >  {1;#DIV/0!;#DIV/0!;0.25;0.5}

=0/{1;0;0;4;2}  > {0;#DIV/0!;#DIV/0!;0;0}

TOP

¦^´_ 4# ­ã´£³¡ªL

±z¦n
¥i¯à¬O§Ú¹ï °}¦C ¤£°÷¤F¸Ñ
©Ò¥H¹ï©ó±zªº»¡©ú§Ú¤´µMµLªk²z¸Ñ
¤£ª¾¦³µL¸û°ò¦ªº¸ê®Æ¥i¥H´£¨Ñµ¹§Ú¬ã¨s¤@¤U¡H
ÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD