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

¥X¶Ôªí¦p¦ó¥Î¨ç¼Æ§PÂ_

ÁÙ¥d¦b¤@­Ó°ÝÃD  ¦pªG  ´£¦­08:00 ªº¬O§PÂ_¬°¦­¨ì
   ¦ý¬O´£¦­12:00ªº ¬O¦­°h  ³o¼Ëªº¸Ü «ç»ò§PÂ_?   
   ´£¦­13:30 ªº¬O§PÂ_¬°¦­¨ì
¦ý´£¦­17:00ªº¤]ºâ¬O¦­°h  ³o¼Ë¦p¦ó§PÂ_?

½Ð°Ý¦U¦ì¤j¤j ³o¼ËÁÙ­n¦A¥[¤@¦æ?ÁÙ¬O?

TOP

¦^´_ 9# p212


    ¤j¤j      =IF($D2-LOOKUP(,0/(MIN(($G$2:$G$3-$D2)^2)=($G$2:$G$3-$D2)^2),$G$2:$G$3)>0,"¿ð¨ì",IF($D2-LOOKUP(,0/(MIN(($G$2:$G$3-$D2)^2)=($G$2:$G$3-$D2)^2),$G$2:$G$3)<=0,"¦­¨ì","·Ç®É",IF($D2-LOOKUP(,0/(MIN(($G$4:$G$5-$D2)^2)=($G$4:$G$5-$D2)^2),$G$4:$G$5)>0,"¿ð¨ì",IF($D2-LOOKUP(,0/(MIN(($G$4:$G$5-$D2)^2)=($G$4:$G$5-$D2)^2),$G$4:$G$5)<=0,"¦­°h","·Ç®É"))))


³o­Ó¦³¿ìªkÁYµu?

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-23 10:10 ½s¿è

¦^´_ 12# keovin790916
©å¨£¡A½Ð°Ñ¦Ò¡I

¥X¶Ôªí³]©w_2.zip (9.28 KB)

TOP

¦^´_ 13# p212

¤j¤j¯u¼F®`     ¦pªG§Ú§ï¦¨³o¼Ë   ¦³¿ìªk¯àÁYµu?

IF(($G2>LOOKUP(,0/(MIN((¥»ªÀ-$G2)^2)=(¥»ªÀ-$G2)^2),¥»ªÀ))*($M2="¤W¯Z"),"¿ð¨ì",IF((($G2<LOOKUP(,0/(MIN((¥»ªÀ-$G2)^2)=(¥»ªÀ-$G2)^2),¥»ªÀ)))*($M2="¤U¯Z"),"¦­°h",""))),IF(($G2>LOOKUP(,0/(MIN((¥»ªÀ-$G2)^2)=(¥»ªÀ-$G2)^2),¥»ªÀ))*($M2="¤U¤È¤W¯Z"),"¿ð¨ì",IF((($G2<LOOKUP(,0/(MIN((¥»ªÀ-$G2)^2)=(¥»ªÀ-$G2)^2),¥»ªÀ)))*($M2="¤U¤È¤U¯Z"),"¦­°h",""))

§Ú·Q»¡­n¤W¯Z ¤U¯Z ¤À¦¨¤W¤È¤U¤È  ¡A ·|¦³ª¬ªp¥u¦³¤U¤È¤W¯Z¤U¯Zªº¥X²{¡A ÁÙ¦³¦pªG¹J¨ì·í¤Ñ¥u¥X¶Ô¤W¤È¤W¯Z ¤§«á¤U¤È¤U¯Zªº  ¦³¨ç¼Æ¥i¥H§PÂ_?

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-24 10:33 ½s¿è

¦^´_ 14# keovin790916
13#°Ýªº¸ê®ÆÄæ¦ì°t¸m¦ü¥G»P­ì°Ý¤£¦P¡I
¥i§_´N13#ªºÀɮ׸ê®Æ(©Î¥t°_½d¨ÒÀÉ)¡A¥[µù±z±ý¼W¦CªºÄæ¦ì¡B¹w´Áµª®×...µ¥¡A¥H¨Ñ¤@¦P½m²ß¡B¬ã¨s¡H
ÁÂÁ¡I

TOP

¦^´_ 15# p212


   
¦p³o¨Ç¬O¦³¤ñ¸û½ÆÂø  ±ø¥ó³]ªº¤ñ¸û¦h

  


½m²ß.rar (10.69 KB)   ½Ð¤j¤j ¬Ý¬Ý

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-25 08:55 ½s¿è

¦^´_ 16# keovin790916
1¡B14#©Ò´£¡u·í¤Ñ¥u¥X¶Ô¤W¤È¤W¯Z ¤§«á¤U¤È¤U¯Zªº¡v(³sÄò­È¶ÔªÌ)¡A16#½d¨ÒÀɤ§KÄæÀ³¬O¥¿½Tªº¡C¦ÓHÄæ¦ì­Y±ý¦A¼Ðµù¡A«h«Øij¤½¦¡¬°
=CHOOSE(MATCH(TEXT(LOOKUP(,0/(MIN((G¸s²Õ-$F2)^2)=(G¸s²Õ-$F2)^2),G¸s²Õ),"hh:mm"),{"08:00";"12:00";"13:30";"17:00"},0),"­È¯Z","","­È¯Z","")
²£¥Í¡u­È¯Z¡vªºµ²ªG
2¡B16#½d¨ÒÀɪº¸ê®Æ¬Ò¬°­È¶Ô¬ö¿ý¡A¬G­pºâ¡u¥X®u¤Ñ¼Æ¡v«Øij¤½¦¡¬°
=SUMPRODUCT(1/COUNTIF($D$2:$D$17,$D$2:$D$17))
3¡B16#½d¨ÒÀɪºG6Àx¦s®æ©Ò­z¡u·|¹J¨ì¦³¨â¤Ñ¥´¥dªº¡v¡A¬°¦ó¡H
4¡B­YE2Àx¦s®æ¬°¤â°Ê¿é¤J¡A«h¥iÂÇ¿é¤J=TEXT(D2,"aaaa")¡A¦V¤U½Æ»s¤½¦¡¡A²£¥Í¡u¬P´ÁX¡vªºµ²ªG¡F©Î¿é¤J=TEXT(D2,"aaa")²£¥Í¡u¶gX¡vªºµ²ªG¡C
¥H¤W©å¨£¡A½Ð°Ñ¦Ò¡I

TOP

¦^´_ 17# p212

·PÁ¤j¤j«ü¾É

¤£¹L«ö³y­È¯Z³o¼Ë ¦ü¥G¨S¿ìªk·í¤Ñ§PÂ_¡C

¹J¨ì¨â¤Ñ¥´¥dªº·N«ä ´N¬O  ¥´¤U¤È¤W¯Z ¤U¤È¤U¯Z  ¦¹Ãþ«¬  ¥i§_§PÂ_¯S§OÅã¥Ü

TOP

¦pªG§ï¦¨ ¤W¤È¤W¯Z ¸ò¤U¤È¤W¯Z ³o¼Ë«á­±´N¨S¿ìªk¦A§PÂ_ ¿ð¨ì ¦­°h³oÃþ?  ÁÙ¬O¦³¨ä¥L¨ç¼Æ¥i¥H¥´¦b«á­±

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD