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

[µo°Ý] ¦p¦ó§PÂ_7¥ð1¶W®É­pºâ(§t«e¤ë¥÷)

[µo°Ý] ¦p¦ó§PÂ_7¥ð1¶W®É­pºâ(§t«e¤ë¥÷)

¦pªG­n§PÂ_¤C¤Ñ¤º¬O§_¦³¥X²{¼Æ¦r"5"¡B"6"¡B"11"µ¥¤T¼Æ¦r
½Ð°Ý¦p¦ó§PÂ_«e¤ë¥÷ªº³Ì«á¤»¤Ñªº®æ¤Æ»yªk¡F¥]§t«e¤ë¥÷¦³28¤Ñ29¤Ñ30¤Ñ¤Î31¤Ñªº¤ë¥÷

²Ä¤C¤Ñ¶}©lªº«Ü¦n­pºâ¡A¦ý¥]§t¨ì¸ó¤ë³¡¤Àªº¤Ñ¼Æ´N¥d¦í¤F¡A¦b½Ð¯¸¤W¤j¤j¥i¥H¨ó§U¤@¤U¡A·PÁÂ

¬¡­¶Ã¯1.rar (10.31 KB)

¦^´_ 1# jackson7015

«Øij¬OÅý¤é´Á³sÄò±Æ¦C¡A
³o¼Ë´N¤£¥Î¦Ò¼{¸ó¤ëªº°ÝÃD¡A
¦Ó®æ¦¡¤Æ¤½¦¡¤]»P§A­ì¥ý³]©w¬Û¦P¡A
¤]µL¶·½Õ¾ã¡A¦p¹Ï©Ò¥Ü¡C
Â^¨ú.GIF
2018-8-13 14:03

TOP

¦^´_ 2# a5007185
·PÁ¤j¤jªº¦^ÂÐ

¦]¬°¦³¨ä¥LÀɮשM®æ¦¡¦s¦b¡A©Ò¥H«e¤ë¥÷¶È¯à©ñ¸m«á¤è
Àɮפ¤ªºÀx¦s®æ¤]¦³³¡¤ÀÁôÂáA¥Nªí¬Ò¦³¨ä¥L¥\¯à¨Ï¥Î
¥[¤W¦pªG¥u¬O³æ¯Â±µÄò«á¤ë¥÷¡A¤]¦³¤j¤p¤ë¶|¦~29¤Ñ°ÝÃD

©Ò¥H·Q¸ß°Ý¬O§_¦³ª½±µ§PÂ_«e«á³¡¤Àªº¿ìªk

TOP

«e­Ó¤ë³Ì«á6¤Ñ

BV48 =IF(COLUMN(A1)>6,"",$D$48-7+COLUMN(A1))
BV49 =TEXT(BV61,"[$-804] aaa;;;")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089
·PÁª©¥D¤j¤jªº¦^´_

¹ï¤£°_¡AÀ³¸Ó¬O§Úªºªí¹F¿ù»~¤F

»Ý¨D¬O­n[D50:I58]¡A³o°Ï¶¡ªºÀx¦s®æ®æ¦¡¤Æ¡A§PÂ_«e¤C¤Ñªº¤º®e¦³¨S¦³¥]§t"5"¡B"6"¡B"11"µ¥¤T¼Æ¦r¡A¦³ªº¸Ü´N¦¨¥ß(¬õ¦r)
²Ä¤C¤Ñ¦]¬°¥i¥H§PÂ_·í¤ëªº³¡¤À¡A©Ò¥H«Ü®e©ö
¥i¬O«e6¤Ñ¦]¬°¥]§t¨ì¤F[BV50:CE58]ªº½d³ò§PÂ_¡A©Ò¥H¤£¾å±o¸Ó¦p¦óµÛ¤â

¦A½Ð«e½ú¬Ý¬Ý¡AÁÂÁÂ

TOP

¦^´_ 5# jackson7015

D50 ®æ¦¡¤Æ¤½¦¡
=SUM(COUNTIF(OFFSET(D50,,,,-MIN(7,COLUMN()-3)),{5,6,11}))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089
·PÁª©¥DML089ªºÀ°¦£

¥Ø«e·í¤ë¥÷ªº²Ä¤C¤Ñ¶}©l³£¯à¥Î¦¹»yªk©ÎÃþ¦ü»yªk°µ§PÂ_
(ª©¤jªº»yªk¦]¬°Áp¶°°Ñ¼Æ¡A©Ò¥H¤£¯à¥Î¦b®æ¦¡¤Æ±ø¥ó¤¤)

¦³§xÃøªº¦a¤è¬O·í¤ë«e¤»¤Ñ­n§PÂ_[BV50:CE58]ªº½d³ò¤£ª¾¹D­n«ç»ò½s¼g
¦³¬d¸ß¹L¯¸¤W¬ÛÃö¸ê®Æ¡A¤j³¡¤À³£¬O¥H³sÄò¤é´Á¤è¦¡¸Ñ¨M
¦ý¬O¦]¬°®æ¦¡Ãö«Y¡A©Ò¥H¤£¯à§ó°Ê¨ì«e­±ªº³¡¤À¤F
¥i¥Hªº³¡¤À´N¬O¦A°µ¥X¤À­¶©ñ«e¤ë¥÷¨Ó°µ³s°Ê§P©w

¬O§_¥i¦A½Ð¤j¤j­Ì¨ó§U¬Ý¬Ý¡A·PÁ¦U¦ì

TOP

D50.±ø¥ó®æ¦¡
=N(COUNT(0/COUNTIF(OFFSET(D50,,,,-MIN(7,DAY(D$48))),CHOOSE(ROW($1:$3),5,6,11)),0/(COUNTIF(OFFSET($CD50,,,,MIN(,DAY(D$48)-7)),CHOOSE(ROW($1:$3),5,6,11))))=0)

¤W¤ë³Ì«á¤»¤Ñ, ¥²¶·±qCDÄ橹¥ª»¼´î±Æ¦C
1

µû¤À¤H¼Æ

    • ML089: {5,6,11} ¦b®æ¦¡¤Æ¤£¯à¨Ï¥Î ¥i¥H§ï¬°CHOOS ...ª÷¿ú + 3

TOP

¦^´_ 8# ­ã´£³¡ªL
·PÁ­㴣³¡ªLª©¤jªº¦^À³

¥ý·PÁª©¥D¤j¤jªº¨ó§U¡A¤½¦¡¥i¥¿±`¹B§@
¤½¦¡ªº½s¼g­nºCºC®ø¤Æ¤F¡A¦nªø¤@¦ê­n¤À¸Ñ²z¸Ñ
ÁöµM»Ý­n¤â°ÊÅÜ°Ê«e¤ë¥÷ªº³Ì«á¤@¤Ñ¤é´Á¦ÜCD¦ì¸m¡A¦ý¤w¸g¸Ñ¨M¤j³¡¤À°ÝÃD¤F

¦Ü©ó«e¤ë¥÷³Ì«á¤»¤Ñªº³¡¤À¡A¬O§_¶È¯à¥H¤â°Ê¤è¦¡±Æ§Ç ?

¦]¬°¥Ø«e¬O¥H¥¨¶°ª½±µ½Æ»s«á­±Àx¦s®æ¦Ü[BV50:CE58]¡AµM«á¦A°µ·í¤ë¥÷ªí®æ
©Ò¥H¨S¦³§PÂ_¥H­þ¤@¤é·í°µ³Ì«á¤@¤Ñ

¦A¦¸·PÁÂÀ°¦£ªº«e½ú

TOP

¦^´_ 7# jackson7015

§Ñ°O¬O¥Î¦b®æ¦¡¤Æ¤½¦¡¤£¯à¥Î {5,6,11}
°Ñ¦Ò­ã¤j¤½¦¡§ï¬° CHOOSE(ROW(1:3),5,6,11)¡A³o¬O«Ü´Îªº¤èªk¡C

§AªºEXCEL¸ê®Æ
D48:AG48 ¬° 2007/9/1 : 2007/9/30
BV48:CD48 ¬° 2007/9/22 : 2007/9/30

¬O§_À³¸Ó§ï¬°
BV48:CE48 ¬° 2007/8/22 : 2007/8/31
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD