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

½Ð°Ý ·j´M¤é´Á ´Á¶¡ ¨Ã¨ú¥X¸Ó´Á¶¡©ú²Ó

½Ð°Ý ·j´M¤é´Á ´Á¶¡ ¨Ã¨ú¥X¸Ó´Á¶¡©ú²Ó

¥»©«³Ì«á¥Ñ mycmyc ©ó 2011-9-24 01:45 ½s¿è

½Ð°Ý ·j´M¤é´Á ´Á¶¡  ¨Ã¨ú¥X¸Ó´Á¶¡©ú²Ó

¦b°_¨´¤é ªí¤º  ´M§ä   °_¤é 90¦~03¤ë01¤é          ¨´¤é        90¦~03¤ë31¤é
µM«á §â¤H¨Æ¸ê®Æ¥þ¦L¥X¨Ó
½Ð¦U¦ì¤j¤j«ü¾É
ÁÂÁÂ

¤H¨Æ.rar (15.3 KB)
HI

A4=IF(SUMPRODUCT((¤H¨Æ¸ê®Æ!$G$3:$G$214>=$C$2)*(¤H¨Æ¸ê®Æ!$G$3:$G$214<=°_¨´¤é!$E$2))>=ROW(1:1),INDEX(¤H¨Æ¸ê®Æ!A:A,SMALL(IF((¤H¨Æ¸ê®Æ!$G$3:$G$214>=$C$2)*(¤H¨Æ¸ê®Æ!$G$3:$G$214<=°_¨´¤é!$E$2)=0,"",ROW(¤H¨Æ¸ê®Æ!$G$3:$G$214)),ROW(1:1))),"")

°}¦C¤½¦¡¿é¤J§¹¶·«ö Ctrl+Shift+Enter ¤TÁä
¥k¦«¤U©Ô~~
¦³°ÝÃD¦A´£¥X!!!

TOP

¦^´_ 2# man65boy
ÁÂÁ§A man65boy
¦n¼F®`ªºÅÞ¿è
³sROW¦h¨Ï¥Î°ÊºA
OK¥i¥H¨Ï¥Î ÁÂÁ§A
¦Ñ¹ê»¡  §ÚÁÙ¦³¤@¨Ç ¨ç¼Æ¹B¥Î ¤£²M·¡
§Ú·|¦n¦n¬ã¨s  ¤£À´¦A¦V§A½Ð±Ð

«Ü¼F®`ªº¨ç¼Æ²Õ¦X   ºô¤Í­Ì­È±o¬ã¨s
§Æ±æ¤j®aÄ~Äò°Q½×  ¥i¥H§ó²`¤J  ¤F¸Ñ  
ÁÂÁ§A  ·P®¦
HI

TOP

¥»©«³Ì«á¥Ñ infoverdad ©ó 2011-9-24 19:54 ½s¿è

¦^´_ 1# mycmyc


    ³oÃD¤]¥i¥Î¶i¶¥¿z¿ï®@!
½Ð°Ñ¦Òhttp://forum.twbts.com/thread-4682-1-1.html 7#ªº¦^ÂÐ!

TOP

¦^´_ 4# infoverdad
  
ÁÂÁ  ¤£¿ùªº¹B¥Î
HI

TOP

¦^´_ 2# man65boy


A4=IF(SUMPRODUCT((¤H¨Æ¸ê®Æ!$G$3:$G$214>=$C$2)*(¤H¨Æ¸ê®Æ!$G$3:$G$214<=°_¨´¤é!$E$2))>=ROW(1:1),INDEX(¤H¨Æ¸ê®Æ!A:A,SMALL(IF((¤H¨Æ¸ê®Æ!$G$3:$G$214>=$C$2)*(¤H¨Æ¸ê®Æ!$G$3:$G$214<=°_¨´¤é!$E$2)=0,"",ROW(¤H¨Æ¸ê®Æ!$G$3:$G$214)),ROW(1:1))),"")

½Ð±Ð¡G¤½¦¡¤¤>¡×ROW(1:1)¤Î³Ì«áªºROW(1:1)¦³¦ó§@¥Î¡H·PÁ½ç±Ð¡I

TOP

¦b©ñ¤J¤½¦¡ªºÀx¦s®æ¡AROW(1:1)´N¬O1
©¹¤U½Æ»s´N·|Åܦ¨2,3,4...¥H¦¹¨Ó±±¨î¦X±ø¥óªºµ§¼Æ¡C
«e­±ªº>=ROW(1:1),ªí¥Ü¦pªG¦³1µ§¥H¤W
«á­±ªºSMALL(IF......ROW(1:1))¬Oªí¥Ü²Ä¤@µ§²Å¦Xªº¡C

TOP

¦^´_ 6# onegirl0204

ROW(1:1) ¬°²Ä¤@¦C ¶Ç¦^ 1 ­pºâSMALL ³Ì¤p­È
¦V¤U©Ô =ROW(2:2) ¶Ç¦^ 2 ­pºâSMALL ¦¸¤p­È

7¼Ó¤j¤j"©Ò¨¥¬Æ¬O"

TOP

½Ð°Ý¦~¸ê¨º¤@Äæ¦ì¡A¨ú¥Xªº­È¡A¤p¼ÆÂI«á¦³¢²¦ì¤Î¢³¦ì¤Î¢´¦ì...µ¥¡A½Ð°Ý¬O§_¥i¥H©M­ì¤u§@ªí¤º­Èªº¤p¼ÆÂI¦ì¼Æ¬Û¦P©O
joyce

TOP

¥»©«³Ì«á¥Ñ mycmyc ©ó 2011-9-28 16:03 ½s¿è

¦^´_ 9# leiru

ÀxÂîæ®æ¦¡  ³]©w¤@¼Ë  ´NOK
©Î¥Î¨ç¼Æ ±±¨î   ¦ý§Ú§Ñ¤F ¨ç¼Æ ¦WºÙ  ¹ï¤£°_   ¦Û¤v¬d¤@¤U
HI

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD