- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¥»©«³Ì«á¥Ñ papaya ©ó 2018-4-30 08:11 ½s¿è
¦^´_ 5# ã´£³¡ªL
¤£¦n·N«ä¡A¨t²Î¨S¦³"´£¿ô"¡Aèè¤~¬Ý¨ì¡C
¦]±zªº¼f·V·r°u¸Ñµª·Ç½T©ÊªººA«×¡A¤p§Ì·Pı²zÀ³¸Ô²Ó¦^ÂÐI´º¸ê®Æ¡A¦³·Ðº¾¦h¨¥¤§³B¡A©|½Ð¨£½Ì¡C
¢°¡D¨C¤ëªº¸ê®Æ¦C¼Æ¬ù30-31¦C¡A20~30Ä楪¥k(¨CÓ·~°Èû1Äæ¡A5~7¤H¬°¤@²Õ¡A¬Ý·~°Èûªº¥X¶Ô²v)¡C
©Ò¥H¦~«×¤]¥u¦³365¦C¡A20Ä楪¥k¡F
¥u¬O¥t¶}¥ßªº¦~«×¾P°â¼Æ¶q²£«~±MÄݳøªíªºÁ`¦C¼Æ·|¹F5000¦C¥ª¥k
¢±¡D¤é³øªíªº¼Æ¦r¬O¤â°Ê¿é¤J¡A¶g³øªí¡B¤ë³øªí¡B¦~«×Á`³øªí«h¥H¤½¦¡¥N¥X¡F
¥u¦³¼ÐÃD¬°¤å¦r¡A¨ä¾l§¡¬°¼Æ¦r(²£«~§Ç¸¹©M¼Æ¶q)¡F ¦ý·|¦³ªÅ¥ÕªºÀx¦s®æ¡C
7¤H²Õªº²£«~¾P°â¤é³øªíÀɮ׮榡¡A¤j·§(µo°Ý¥Î¡AµL¼Æ¶qÄæ¡A¨S¦³«Üºë·Ç)¦p
http://forum.twbts.com/thread-20733-1-1.html
µo°Ý«e³£·|¥ý¤Wºô¬d¸ß¸ê®Æ¡A¦³·j´M¨ì
http://forum.twbts.com/viewthrea ... amp;highlight=LARGE
¤]¬O"LARGE+FREQUENCY"¡F¦ý¤å¤¤´£¨ì¡J¸ê®Æ3000¦C´N¤£¦n¥Î¡A¥²¶·¦A³]"©w¸q¦WºÙ"¡A
ı±o³Â·Ð¡A©Ò¥H¤W¨Óµo°Ý¡A§Æ±æ¯à§ä¨ì§ó¨Îªºµª®×¡C
±zªº¸Ñµª¤½¦¡°w¹ï¯S©Ê¦U¦³©Ò¥Î¡A¤p§Ì±Ä¥Î
=MAX(A:A)=A1
=SMALL(A:A,FREQUENCY(A:A,MAX(A:A)-1))=A1
=SMALL(A:A,FREQUENCY(A:A,MAX(A:A)-2))=A1
¨ú¨ä¯Â¼ÆÈ©M¤½¦¡È§¡¥i¥Î¡A¨Ã¥i²¤¹LªÅ¥ÕÀx¦s®æªºÀuÂI¡A
¤×¨ä¬O¥iÂI¿ï"¾ãÄæ"¡A¤£»Ýn©ÔÓn©R¥h¿ï¨úÀx¦s®æ½d³òªº¯S©Ê¡C
«D±`·PÁ±zªº¼ö¤ß¨ó§U©M@¤ß«ü¾É!·P®¦! |
|