- ©«¤l
- 186
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-11-12
- ³Ì«áµn¿ý
- 2014-4-15
|
¦^´_ 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)¬On³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 |
|