[µo°Ý] [µo°Ý] ¨Ì±ø¥ó¸õ¿ïÀx¦s®æ­È

ABK

½Ð°Ý¦³¿ìªk¨Ï¥Î¤½¦¡ ¨Ì±ø¥ó¸õ¿ïÀx¦s®æ­È¶Ü?

ABK

¦^´_ 8# ­ã´£³¡ªL


    ·PÁ ­ã´£¤j !
    ok¤F!

­ã´£³¡ªL

¦^´_ 7# ABK


=IFERROR(LOOKUP(1,0/(MOD($F2:$AJ2/(1&$F1:$AJ1),7)>1)/($F2:$AJ2<G4),$F2:$AJ2),"")

ABK

¦^´_ 6# ­ã´£³¡ªL


  ÁÂÁ­㴣¤j !

¤£¦n·N«ä!  ¬O§Ú¨S»¡©ú²M·¡!  ¾î¦¡ªº¤é´Á±Æ¦C ¥u¦³ F1: AJ2¡A ¨S¦³AÄæ©MBÄæ¨â¦C¤F¡A
§Y§Ú·Q±N­ì¥»ª½¦¡ªº¤é´Áªí§ï¦¨¾î¦¡ªº¤é´Áªí, ¨Ï¥Î¾î¦¡ªº¤é´Áªí¨ÌµM¦³¬D¿ï³Ì«á¨â­Ó¤u§@¤éªº¥\¯à¡C

­ã´£³¡ªL

¦^´_ 5# ABK


F4:
=iferror(LOOKUP(1,0/(MOD($B$1:$B$99/(1&$A$1:$A$99),7)>1)/($B$1:$B$99<G4),$B:$B),"")

ABK

¦^´_ 3# ­ã´£³¡ªL

­ã´£¤j±z¦n!  ¦A½Ð±Ð¤@¤U!

­Y±N ¤é´Á§ï¦¨¾î¦V¡A ¦bH4 ¿é¤J¤é´Á®É, «h G4Åã¥Ü«e1­Ó¤u§@¤Ñ »P F4Åã¥Ü«e2­Ó¤u§@¤Ñªº¤é´Á¡A ¤½¦¡­n¦p¦ó­×¥¿?

ABK

ÁÂÁÂHsieh¤j©M­ã´£¤j!
±z­Ìªº¤½¦¡³£¦n¥Î!    ·PÁ ·PÁÂ!

¤@¶}©l¨S¥hÅܧó§ÚBÄ檺[©P¤».©P¤é]±ø¥ó®æ¦¡´N¥ý¸Õ¤½¦¡, ¸Õ¤F¤@°}¤l ı±o¼Æ­È³£©Ç©Çªº,
¦n¦b­ã´£¤j¦³´£¿ôªÈ¥¿,«á¨Ó¤~µoı¬O°²¤é¦ì¸m¼Ð¿ù¤F¡A¤£¬O¨â¦ìª©¤jªº¤½¦¡¤£ÆF¡C

·PÁ¸U¤À !

­ã´£³¡ªL

1) BÄæ[©P¤».©P¤é]±ø¥ó®æ¦¡¿ù»~:
    «Øij­×§ï:B1±ø¥ó¤½¦¡
    ±ø¥ó¤@:=$A1<>""     ³][²H¬õ¦â]
    ±ø¥ó¤G:=WEEKDAY($B1&"",2)>5   ³][¶À¦â]

2) E6¤½¦¡:¤U©Ô
   =IFERROR(LOOKUP(1,0/(MOD(B$1:B$30/(1&A$1:A$30),7)>1)/(B$1:B$30<E7),B:B),"")
   ©Î
    =IFERROR(LOOKUP(1,0/(WEEKDAY(B$1:B$30/(1&A$1:A$30),2)<6)/(B$1:B$30<E7),B:B),"")

Hsieh

¦^´_ 1# ABK

E6°}¦C¤½¦¡
=WORKDAY($E$8,-2+ROW(A1)-1,SMALL(IF(($A$1:$A$30<>"")+(WEEKDAY($B$1:$B$30,2)>5),$B$1:$B$30,""),ROW(INDIRECT("A1:A"&SUMPRODUCT(($A$1:$A$30<>"")+(WEEKDAY($B$1:$B$30,2)>5))))))

¤U¸ü (39.02 KB)

2018-11-29 09:27