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

[µo°Ý] §ä¥X¦U¸s²Õªº²³¼Æ(¤£§t0)

¦^´_ 54# ML089

§Ú¥Î¶À©³¼Ð¥Ü¦³°ÝÃDªº³¡¥÷.

D76
D289
D1637
D1708

²³¼Æ_¥t¤@¸Ñ_ML089_MOD_MAX_INDEX_FREQUENCY_ROW.zip (42.46 KB)

TOP

¦^´_  ML089

·PÁ±z¦³¿³½ì¸Ñµª³o¤@ÃD,§Ú±N¤½¦¡®M¤J¥¿¦¡ªº¼Æ­È¤¤,µ²ªG¦³ªº²³¼Æ¤£·|¦b²Ä¤@¦¸¥X²{ªº¦ì¸mÅã ...
PJChen µoªí©ó 2013-4-10 18:05



    §Ú¬Ý¤@¥b¼Æ¾Ú¤F³£¬O¦b¨C²Õ²³¼Æ²Ä¤@¦ì¸m¥X²{¡A§A§â¬Ý¨ì¦³°ÝÃDªº¦ì¸m¦A§i¶D§Ú
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 34# ML089

·PÁ±z¦³¿³½ì¸Ñµª³o¤@ÃD,§Ú±N¤½¦¡®M¤J¥¿¦¡ªº¼Æ­È¤¤,µ²ªG¦³ªº²³¼Æ¤£·|¦b²Ä¤@¦¸¥X²{ªº¦ì¸mÅã¥Ü¥X¨Ó?¤£ª¾­þ¨à¥X¿ù?

²³¼Æ_¥t¤@¸Ñ_ML089_MOD_MAX_INDEX_FREQUENCY_ROW.zip (41.71 KB)

TOP

ISERR(-B2) §PÂ_¬O§_¬°¤å¦r¡A­Y¬O¤å¦r -B2 ·|²£¥Í¿ù»~

COUNIFS ¥\¯à±j¤j¥i¬O§Ú¤£¤Ó³ßÅw¥Î¡A¦]¬°«Ü¦hÃD¥Ø¤´»Ý²Å¦X 2003ª©¤~¯à¾A¥Î
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 50# ML089


=IF(ROW()=COUNTA(B:B)+1,COUNTIF(A:A,">"&MAX(B:B)),IF(OR(ISERR(-B2),MATCH(B2,B:B,)<>ROW()),0,COUNTIF(A:A,"<="&B2)-IF(B2=MIN(B:B),0,COUNTIF(A:A,"<="&SMALL(B:B,COUNTIF(B:B,"<"&B2))))))

¨ü±Ð¤F¡I
¥Îmatch(B2,B:B,)<>row()¨Ó§PÂ_­«½Æ¡A¤ñIF(COUNTIF(OFFSET($B$2,,,ROW()-1,),B2)>1,0,......)º}«G¦h¤F
¤£¹L·Q½Ð±Ð¤@¤UISERR(-B2)¬O­n³B²z¤°»òª¬ªp¡H
¥t¥~¥ÎSMALL(B:B,COUNTIF(B:B,"<"&B2))¤]«Üº}«G¡A¤£»Ý¨Ï¥Î°}¦C¤½¦¡´N¯à¹F¨ì¡u¦¸¤p­È¡vMAX(IF(bin_array<B2,bin_array,""))ªº®ÄªG
µM«á¥Î´îªº¨Ó¨ú¥Ncountifs¤]¬O­Ó¦n¥D¸q
ÁöµMµ²ºc·|¨S¨º»ò²M·¡(§â§Ú­ì¥»4,5µ²¦X¦b¤@°_)¡A¦ý¬O´N¤½¦¡¦Ó¨¥¡A¯uªº¥Îªº«Üº}«G¡I

¤£¹L§Ú­ì¥»ªººÃ°Ý¤ñ¸û¬Ooffset©M©w¸q¦WºÙªº°ÝÃD
§Ú¥t¥~µo¤F¤@½g"offset»P©w¸q¦WºÙ"¡AÀ³¸Ó¦³§â°ÝÃDÁ¿ªº¤ñ¸û²M·¡¤@ÂI

TOP

¦^´_ 49# Bodhidharma

I2
=IF(ROW()=COUNTA(B:B)+1,COUNTIF(A:A,">"&MAX(B:B)),IF(OR(ISERR(-B2),MATCH(B2,B:B,)<>ROW()),0,COUNTIF(A:A,"<="&B2)-IF(B2=MIN(B:B),0,COUNTIF(A:A,"<="&SMALL(B:B,COUNTIF(B:B,"<"&B2))))))

¤@¯ë¤½¦¡

¦¹¤½¦¡¼ÒÀÀ FREQUENCY ¦ý¨S¦³³B²z bin_array ¦³«D¼Æ­È¤§±¡ªp¡A
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 48# ML089


·PÁ»¡©ú

§Ú¸Õ¹Ï§â¤½¦¡¼g¦b¦P¤@¦æ¡A¤£¹Lµo²{¥\¤O¤£¨¬
ª½¦n¥t¥~¥[¤@¦æ¡A§â­ì¥»ªºµ²ªG·í¦¨»²§U¦C
frequency¨ç¼Æ»¡©ú(³B²z«D¼Æ¦r).png
2013-4-9 19:47

ª½Ä±¤WÀ³¸Ó¬O­n¥Î©w¸q¦WºÙ¡A¤£¹L§Ú©w¸q¦WºÙÁÙ¤£°÷¼ô
¤£·|³B²z³oºØ¦³°ÊºA½d³òªº¤½¦¡¡GIF(COUNTIF(OFFSET($B$2,,,ROW()-1,),B2)>1,0,......)

·Q½Ð±Ð³oºØ¦³°ÊºA½d³òªº¤½¦¡¡A¬O§_¥i¥H¥Î©w¸q¦WºÙ³B²z¡H
(ÁÙ¬O»¡³o¸ò¥»¤£¬O©w¸q¦WºÙªº°ÝÃD¡H)

frequency¨ç¼Æ»¡©ú(³B²z«D¼Æ¦r).rar (12.37 KB)

TOP

¦^´_ 47# Bodhidharma


¦pªG¯à¼ÒÀÀ¥X¥¿½Tµª®×¡A¹ïFREQUENCY¨ç¼Æ¤w¸g¥R¤À¤F¸Ñ
¥t¥~¥[¤@ÂI¡A«D¼Æ¦r¦Û°Ê±Æ°£¡A­pºâ­È·|©¹«e±Æ¦C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 46# Bodhidharma

frequency¨ç¼Æ»¡©ú.png
2013-4-8 21:18

§â¾ã­Ó¨ç¼Æ¼g¦b¤@°_¡A°ò¥»¤WÀ³¸Ó´Nº¡²M·¡ªº
½Ð¤j®aÀ°§Ú¬Ý¤@¤U³o¼Ëªº·§©À¥¿¤£¥¿½T
frequency¨ç¼Æ»¡©ú.rar (10.83 KB)

TOP

¦^´_  Bodhidharma


bin_array ¤£¥Î±Æ§Ç¡A­Y¦³­«½Æ¼Æ®É¡A­pºâ­È·|¼Ðµù©ó²Ä¤@¦¸¥X²{¤§¼Æ¦ì¸m¨ä¥L¬°0
ML089 µoªí©ó 2013-4-8 17:28


¶â¡A¤Ï¥¿result_array[x]´N¬O¦^¶Ç¡u¤p©óµ¥©óbin_array[x]¡A¥B¤j©ó"bin_array¤¤¡A¦¸¤p©óbin_array[x]"¡v³o­Ó°Ï¶¡ªº¼Æ­È­Ó¼Æ
¦pªG¤w¸g¬Obin_array¤¤³Ì¤pªº¡A«h¦^¶Ç©Ò¦³¤p©óµ¥©ó¸Ó­Èªº­Ó¼Æ
­Y¦³­«½Æªº¸Ü´N¼Ðµù²Ä¤@­Ó¡A¨ä¥¦¬°¹s
µM«á¤j©óbin_array¤¤³Ì¤j¼Æ­È­Ó¼Æªº¡A´N©ñ¦bresult_arrayªº¦C«á¤@¦C

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD