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

«ç»ò¥Î¨ç¼Æ¨D¥X²Ä¤T¤jªº¼Æ ?

应该¬O¦b没¦³ÚÌ©w错误ªº±¡况¤U¤~¨Ï¥Îon error
学习

TOP

¤£¾å±o³o¼Ë¦X¥Î¶Ü
{=LARGE(IF(FREQUENCY(A2:A17,ROW(1:99)),ROW(1:100),0),3)}

Book1.rar (2.13 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 12# gong


    ­YCÄ椤ªº¼Æ­È«Ü¤j®É¦p¶W¹L65536
®£©È´NµLªk¨Ï¥Î¦¹ªk¤F
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§Ú¤]ª¾¹D³o¼Ë¦³ÂI°½Âû
¥Î¨ç¼ÆÁÙ¯u¤£¦nª±
¥u¯à»¡¼Ó¥D¥XªºÃD¥Ø³£®¼¦³²`«×
­È±o¨Ó¾Ç²ß¤Î°Ê°Ê¸£
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-7 00:05 ½s¿è

{=INDEX(A2:A100,MATCH(LARGE(IF(ISNUMBER(MATCH(ROW(1:100),RANK($A$2:$A$100,$A$2:$A$100,1),0)),ROW(1:100),0),3),RANK($A$2:$A$100,$A$2:$A$100,1),0))}

gong.rar (4.76 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

gong ª©¥D
ÁÙ¬O¥i¥H¥Î¦^­ì¨Óªº FREQUENCY ¨ç¼Æ

{=LARGE(IF(FREQUENCY(A1:A100,A1:A100),A1:A100),3)}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¸Ñªº¦n,¾Ç²ß¤F
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 16# zz5151353

©ç¤â¥s¦n.gif
­ì¨ÓFREQUENCYªºbins_array¬O¤£»Ý­n³sÄò¼Æ­È¤Î³æ¤@©Ê
³o¨ç¼Æ«Ü¤Ö¥h¥Î¥L­È±o¬ã¨s¬Ý¬Ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¼M
´Î¯Å¤F,«D±`ºë±m
·PÁ¼ӤW¦h¦ì«Ó­ôª©¥D¸ò«Ó­ô¾Çªø
·P®¦¥[·PÁ±z­Ì
§¹¥þ¥i¥H¹F¨ì
«D±`ªº·P°Ê©O
±z­Ì¯u¬O¤Ó±j¤Ó±j¤F
·PÁ±z­Ì¨Ã¯¬¶P±z­Ì
©¯ºÖ¦n¹B¥Ã»·­°Á{±z­Ì¨­¤W

TOP

¦hÁ wqfzqgk «Ó­ô¾Çªø

±zªº¤½¦¡ÁöµM¯à¥Î

¦ý¤£¬O¾Ç©f­nªº,¨D¥Xªº¼Æ¾Ú¬O 99 ­C (¤£¹ï¤£¹ï)

¬O­n 97 ...
metrostar µoªí©ó 2010-7-6 17:18



©_©Ç¤F¡A¤p§Ì¸Õ¬O¥¿±`ªº
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD