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

½Ð°Ý®æ¦¡¤Æ±ø¥ó+¨ç¼Æ

½Ð°Ý®æ¦¡¤Æ±ø¥ó+¨ç¼Æ

¦p¦ó³]©w®æ¦¡¤Æ±ø¥óÅý¨S±Æ¨ì¯ZªºÅܦâ
*¥­¤é¯Z´N¬O·|¦³2­Ó¤H
*°²¤é¯Z´N¥u·|¦³2­Ó¤H




¯Zªí.rar (16.92 KB)
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

¥»©«³Ì«á¥Ñ yen956 ©ó 2016-1-28 15:24 ½s¿è

1.
*¥­¤é¯Z´N¬O·|¦³2­Ó¤H
*°²¤é¯Z´N¥u·|¦³2­Ó¤H
¬O¤°»ò·N«ä?
2. ¨® ¤S¬O¤°»ò·N«ä?

¤°»ò±¡ªp­nÅܦâ,
½ÐÁ|¨Ò»¡©ú²M·¡¤@ÂI¦n¶Ü?(«ÜÃø²q)

TOP

A1Àx¦s®æ-®æ¦¡-³]©w®æ¦¡¤Æ±ø¥ó-¤½¦¡¬°-=IF(OR(A1="",A1=" "),TRUE,FALSE)-³]©w»Ý¨DÅܦâ
DATA-ÂлsA1®æ¦¡¦ÜALL»Ý¨DÀx¦s®æ(¥Î±½§â²Å¸¹¤§¥\¯àÁä)
ù

TOP

¦^´_ 2# yen956

¦p¦ó³]©w®æ¦¡¤Æ±ø¥óÅý"¨S±Æ¨ì¯Zªº®æ¤l"Åܦâ
*¥­¤é¯Z·|¦³3­Ó¤H¾¯Z1­Ó¤é¯Z1­Ó©]¯Z¥[1­Ó¨®¹D¤H­û
*°²¤é¯Z´N¥u·|¦³2­Ó¤H¾¯Z 1­Ó¬O¤é¯Z 1­Ó©]¯Z
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

¥»©«³Ì«á¥Ñ yen956 ©ó 2016-1-28 19:51 ½s¿è

1. ¿ï¨ú E3:E6       
2. ³]©w®æ¦¡¤Æ±ø¥ó, ¿ï¤½¦¡¬°...        
    ¿é¤J¤½¦¡¡G=IF(OR(E$3:E$6=""),OR((AND(COUNTIF(E$3:E$6,">""")<3,WEEKDAY(E$1,2)<6)),(AND(COUNTIF(E$3:E$6,">""")<2,WEEKDAY(E$1,2)>5))))       
3. ³]©w®æ¦¡
4. ¿ï¨ú E3:E6¡÷½Æ»s¡÷¿ï¨ú­n½Æ»sªº½d³ò¡÷¿ï¾Ü©Ê¶K¤W¡÷®æ¦¡
Sorry, ¦¹¤½¦¡©|¤£

TOP

¥»©«³Ì«á¥Ñ yen956 ©ó 2016-1-28 19:54 ½s¿è

Sorry, ¦¹¤½¦¡ÁÙ¤£²z·Q, ·|¾ãÄæ(4®æ)¤@°_¦Û°Ê®æ¦¡¤Æ, ¦p¦ó±Æ°£, ¦³½Ð°ª¤â«ü¾É.
¦ý¤w¥i§ä¥X­È¯Zªí¨º¸Ì±Æ¿ù¤F.

TOP

Sorry, ¦¹¤½¦¡ÁÙ¤£²z·Q, ·|¾ãÄæ(4®æ)¤@°_¦Û°Ê®æ¦¡¤Æ, ¦p¦ó±Æ°£, ¦³½Ð°ª¤â«ü¾É.
¦ý¤w¥i§ä¥X­È¯Zªí¨º¸Ì±Æ¿ù¤F ...
yen956 µoªí©ó 2016-1-28 19:51

«D±`·PÁÂ
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

¢Ó¢²¡D®æ¦¡¤Æ±ø¥ó¡D¤½¦¡¡G
=(E3="")*($C3<>"")*(SUM(N(E$3:E$10<>""))<>3-(MOD(E$1,7)<2))

³]¦n«á¡A¦A¡e®æ¦¡½Æ»s¡f¨ê¦Ü¨ä¥¦®æ¡ã¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD