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

[µo°Ý] ½Ð±Ð¤½¦¡

[µo°Ý] ½Ð±Ð¤½¦¡

½Ð±Ð¥ý¶i
¤½¦¡­þ¸Ì¿ù¤F?  ¦p¤º¤å ¬¡­¶Ã¯11.rar (9.52 KB)

FREQUENCY(data_array,bins_array)
Data_array {3,5,7...}
Bins_array {4,5,6,7...|

Bins_array 4 ®·Àò Data_array 3¡A©Ò¥H¦³ 4
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

­ì¦¡=IFERROR(SMALL(IF(FREQUENCY($AC$6:$AJ$13,ROW(5:103)-1),ROW(5:103)-1),COLUMN(A5)),"")

­×§ï =IFERROR(SMALL(IF(FREQUENCY($AC$6:$AJ$13,ROW(5:103)-1),ROW(5:104)-1),COLUMN(A5)),"")

FREQUENCY ¬O¤À¬q²Î­p¨ç¼Æ¡A¿é¥Xµ²ªG·|¤ñBins_array¦h¤@­Ó
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁ ML089 ¤j¤j«ü¾É..¦ÑªÌ²Â©å..ÁÙ¬O¨S§@¥Î ?
½Ð¤£§[¦A«ü¾É  ·PÁÂ

TOP

¦^´_ 4# duck_simon

¤£ª¾¹D§Aªº¤½¦¡­n¨D¤°»ò?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

­ì¤½¦¡ ¦³¥ô¤@ <=4 ¼Æ¶qµL­­ ²Ä¤@­È §¡¬° 4 ©Ò¥H¤£¾A¥Î

{=IFERROR(SMALL(IF($AC6:$AJ13>0,$AC6:$AJ13),COLUMN(A1)),"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

­ì¤½¦¡ ¦³¥ô¤@ 0,$AC6AJ13),COLUMN(A1)),"")
hcm19522 µoªí©ó 2021-7-30 11:28



·PÁÂ2¦ì¤j¤jµ¹¤© «ü¤Þ..¥i¥H¤F

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD