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

§Y®ÉÅã¥Ü¤£¦PÀx¦s®æ¼Æ­È

§Y®ÉÅã¥Ü¤£¦PÀx¦s®æ¼Æ­È

½d¨Ò.rar (2.44 KB) ½Ð°Ý¦U¦ì¥ý¶i¤Î«e½ú¦p¦ó¦b©T©wÀx¦s®æÅã¥Ü¨ä¥¦Àx¦s®æªº¼Æ­È,¼Æ­ÈÀH®É§ó·s,¸Ô²Ó»¡©ú©óªþÀɤº,¥ýÁÂÁ¦U¦ì¥ý¶i¤Î«e½ú!!

¥»©«³Ì«á¥Ñ p212 ©ó 2014-8-22 14:04 ½s¿è

¦^´_ 1# shan0948
¸Ñ1¡G°}¦C¤½¦¡
Àx¦s®æH8=OFFSET(E$2,LARGE(IF($A$3:$A$8=DATE(2014,8,1),ROW($A$3:$A$8),FALSE),1)-2,0)
¦V¥k½Æ»s

¸Ñ2¡G°}¦C¤½¦¡
Àx¦s®æH8=INDEX(E$3:E$8,LARGE(IF($A$3:$A$8=DATE(2014,8,1),ROW($A$3:$A$8),FALSE),1)-2)
¦V¥k½Æ»s
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212


    P212±z¦n,·PÁ«ü¾É¨ó§U¤½¦¡ªº³]©w,¦ý°õ¦æ¤W¦³°ÝÃD,·í¿é¤J§¹8/1«á¥i¥HÅã¥Ü©Ò­nªº¤G­Ó¼Æ­È,¦A¿é8/2¸ê®Æ«á,H8:I8´NµLªkÅã¥Ü8/2ªº¤G­Ó¼Æ­È,¦PÅvªº¦pªG8/2ÁÙ¦³²Ä¤Gµ§¸ê®Æ¿é¤J¥ç¦P¼Ë±¡ªp,¤é´Á¸ê®Æ·|¤@ª½¼W¥[¤U¥h,¥»ªí³Ì¥D­n¥Øªº¬O­nÀH®É¬Ý¨ì³Ì·sªº¤GÄæ¼Æ­È¸ê®Æ,½Ð¤j¤j¦A¤©¥H¨ó§U«ü¾É,ÁÂÁÂ!!

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-8-22 17:15 ½s¿è

¦^´_ 3# shan0948
1¡B¥i¦Ò¼{ª½±µÅܧó°}¦C¤½¦¡¤¤¬õ¦â³¡¤Àªº¦~¤ë¤À¤Î¤é´Á
Àx¦s®æH8=OFFSET(E$2,LARGE(IF($A$3:$A$8=DATE(2014,8,1),ROW($A$3:$A$8),FALSE),1)-2,0)
©Î
Àx¦s®æH8=INDEX(E$3:E$8,LARGE(IF($A$3:$A$8=DATE(2014,8,1),ROW($A$3:$A$8),FALSE),1)-2)

2¡B©ÎªÌ¦Ò¼{«ü©w¬Y¤@¯S©wÀx¦s®æ¬°¡u¤é´Á¡v¤ñ¹ï¼Ðªº¡A¦pÀx¦s®æH6 (©ó¦¹¿é¤J2014/8/1)¡A«h°}¦C¤½¦¡­×§ï¬°
Àx¦s®æH8=OFFSET(E$2,LARGE(IF($A$3:$A$8=$H$6,ROW($A$3:$A$8),FALSE),1)-2,0)
©Î
Àx¦s®æH8=INDEX(E$3:E$8,LARGE(IF($A$3:$A$8=$H$6,ROW($A$3:$A$8),FALSE),1)-2)
½Ð°Ñ¦Ò¡I
µù¡G°}¦C¤½¦¡½Ð¥HCtrl+Shift+Enter¿é¤J

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-8-22 17:28 ½s¿è

¦^´_ 3# shan0948
­Y¬O¸ê®Æµ§¼ÆÀH¤é´Á¤£Â_¼W¥[¥B­nÀH®É¬Ý¨ì³Ì·sªº¤é´Á¡A«h¥i­×§ï°}¦C¤½¦¡¬°
Àx¦s®æH8=OFFSET(E$2,LARGE(IF($A$3:$A$8=MAX($A$3:$A$8),ROW($A$3:$A$8),FALSE),1)-2,0)
©Î
Àx¦s®æH8=INDEX(E$3:E$8,LARGE(IF($A$3:$A$8=MAX($A$3:$A$8),ROW($A$3:$A$8),FALSE),1)-2)
½Ð°Ñ¦Ò¡I
µù¡G$A$3:$A$8½d³ò½Ð¦Û¦æ½Õ¾ã¡F©Î¥t¥H©w¸q¦WºÙ¤è¦¡³B²z¦¨°ÊºA½d³ò¡A¨Ò¦p©w¸q¦WºÙ¡u¤é´Á¡v¡A°Ñ·Ó¨ì¿é¤J=OFFSET(Sheet1!$A$3,,,COUNTA(Sheet1!$A:$A))¡C¤W¦C¤½¦¡$A$3:$A$8³¡¤À­×§ï¬°¡u¤é´Á¡v¡C

TOP

¦^´_ 5# p212

P212±z¦n¡A·PÁ¦A«×«ü¾É¨ó§U¤½¦¡ªº³]©w¡A¸g¹L´ú¸Õ«á¤w²Å¦X»Ý¨D¡A¥i¥Hª½±µ¥H¤é´Á§@¬°Åã¥Ü¨Ì¾Ú¡A¤£¥²¥t³]©w¸q¦WºÙ¡A¦p¦¹´N¥i¥H¦b¨ä¥L¦a¤è¬Ý¨ì³Ì·s¸ê®Æ¡A«D±`¹ê¥Î¹ï¤u§@¤W¦³·¥¤j§U¯q¡A¦A«×·PÁÂP212¤j¤jªº«ü¾É¡A¤]¾Ç¨ì¤F§Þ¥©¡I

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD