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

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

¦^´_ 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

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

¦^´_ 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

¦^´_  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

¦^´_ 54# ML089

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

D76
D289
D1637
D1708

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

TOP

¦^´_ 33# Bodhidharma

©êºp²{¦b¤~¦^ÂÐ,³s¥ð«á¤@¤W¯Z,¨C¤Ñ³£¦£­Ó¥b¦º..
¤£¹L§ÚÁÙ¬O­n»¡©ú,Àɮפ¤ÁöµM¥u¦³¤G­Ó¦Û©w¸q,§ÚÁÙ¬O°¾·R¬Ý±o¨£ªº¤½¦¡.
§Ú±N¤½¦¡®M¤J¥¿¦¡ªº¼Æ­È¤¤,µ²ªG¦³ªº²³¼Æ¤£·|¦b²Ä¤@¦¸¥X²{ªº¦ì¸mÅã¥Ü...
C289
C1708

²³¼Æ_3_³¡¥÷¦Û©w¸q¦WºÙ.zip (42.43 KB)

TOP

¦^´_ 25# Hsieh

ª©¤j,§ÚÁÙ¬O­n¦A»¡¤@¦¸,·PÁ§AÀ°¦£±N¦Û©w¸q§ï¬°»²§U¤½¦¡.
§Ú±N¤½¦¡®M¤J¥¿¦¡ªº¼Æ­È¤¤,µ²ªG¦³ªº²³¼Æ¤£·|¦b²Ä¤@¦¸¥X²{ªº¦ì¸mÅã¥Ü,§Ú¥i¯à¼Ð±o¤£¤Ó¦n,¦]¬°¦³ÂI¿ùºî½ÆÂø...    ²³¼Æ_Hsieh 2.zip (79.07 KB)

C289
C392
C395
C548
C553
C714
C1047
C1052
C1225
C1228
C1708
C1710
C1712

TOP

¦^´_  Bodhidharma

©êºp²{¦b¤~¦^ÂÐ,³s¥ð«á¤@¤W¯Z,¨C¤Ñ³£¦£­Ó¥b¦º..
¤£¹L§ÚÁÙ¬O­n»¡©ú,Àɮפ¤ÁöµM¥u¦³¤G ...
PJChen µoªí©ó 2013-4-10 21:47



½Ð§A§â§Aªº»Ý¨D¶}²M·¡
©Ò¿×ªº"²³¼Æ"¨ì©³¬O¤°»ò·N«ä¡H
§Ú«e­±¤@ª½¦b°Ý¡A¦ý¤´µM±o¤£¨ì¤@­Ó©ú½Tªºµª®×

§Aªº´ú¸ê¤w¸g¶}©lÅý§Ú¤@ÀYÃú¤ô¤F¡K¡K



(¸Ü»¡§Úªº¤½¦¡©MML089ªºµ²ªG¡A°ß¤@ªº®t§O¬O¡u·í©Ò¦³¼Æ³£¥u¥X²{¤@¦¸®É¡AML089ªº¤½¦¡·|º|±¼¡A¥þ³¡¤£¼Ð¡v¡A¨ä¥¦ªºµ²ªG³£·|¤@¼Ë¡K)

TOP

¦^´_  ML089

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

D76
D289
D1637
D1708
PJChen µoªí©ó 2013-4-10 21:38


¥Ø«e¤½¦¡¬O¼Ð¥Ü¦b³Ì¤j³sÄò¼Æªº²Ä¤@­Ó³sÄò¼Æ¦ì¸m¡A¨Ã¤£¬O²Ä¤@­Ó¥X²{ªº¦ì¸m¡A³o¤]¤ñ¸û¦X²z¡A¦P®É«ü¥X³Ì¤j³sÄò¼Æªº°_©l¦ì¸m¡C
½Ð¦b«ä¦Ò¬Ý¬Ý
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 59# ML089
¦^´_ 58# Bodhidharma
¦^´_ 25# Hsieh

¦U¦ì,

§Ú¸ÑÄÀ¬°¤°»ò§ì¤£¥X¤@­Ó·Ç«hªº­ì¦]:
©Ò¦³ªº¼Æ­È¬O¥Ñ¤@­Ó¹qªí©Ò§ì¨ú¥X¨Óªº¼Æ¾Ú,¼Æ¾Ú¬O¥Î¨Ó¤ÀªR¤@¨Ç¹q¤è­±ªº¯Ó¹q¡B«×¼Æ¡B¤Î«Ü¦h§Ú¤£À´ªº±M¦³¦Wµü.
¹qªí¬OÂ_Äò±Ò°Êªº,¬ù±Ò°Ê­Ó´X¤Ñ,´N·|®³³o¨Ç¼Æ¾Ú¨Ó§@¤ÀªR,¥Ñ©ó¥¦¶]¥Xªº¼Æ­È¤j¤p³£¬O¥¼ª¾¼Æ,©Ò¥H¤~­n¤ÀªR,
¦ý¦U¦ì¤]¬Ý¨ì¤F¼Æ¾Úªº¤@¨Ç¯íÂI...§ì¤£¥X·Ç«h¤£ª¾¦p¦ó©w¤½¦¡?
§Ú¤w¸ò§Úªºuser°Q½×¹L,¦]¬°¦b²³¼Æ¤è­±¯uªº«ÜÃø§ì¥X¤@­Ó·Ç½Tªº¤è¦V,©Ò¥H§Ú»¡ªA¥L©ñ±ó²³¼Æªº»Ý¨D,§ï¥Î¨ä¥L¤è¦V¥h§ì©Ò»Ý¼Æ­È,
¨ä¹ê§Ú­n¨D¥Lµ¹§Ú¤£¦P¤Ñªº¹qªí¼Æ¾Ú,·Q°µ"¨D¤½¦¡,¤£ª¾¦p¦ó¤U¼ÐÃD?"ªºÅçºâ,¦ý¤@®³¨ì¤âµo²{,²Ä¤G¥÷¼Æ¾Ú®M¥Î¦b«e­±°Q½×«Ü¦h¤Ñªº"¨D¤½¦¡,¤£ª¾¦p¦ó¤U¼ÐÃD?",¤w¥X²{¤F«Ü¦h¿ù»~¦a¤è,§ó§O½Í"²³¼Æ"³o­ÓijÃD.

«Ü©êºp´£¥X¤@­ÓµLªk¸Ñ¨Mªº°ÝÃDÅý¤j®a¶Ë¸£µ¬! §Ú¦Û¤v¬Ý¨ì²Ä2¥÷³øªí¤]¬O§Ö¸£¥R¦å¤F,ÁÙ¤£ª¾¹D­n¦p¦ó¥h¶i¦æ....

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD