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

¹A¾ä¤ÀªR·f°t¦¯

¹A¾ä¤ÀªR·f°t¦¯

½Ð°Ý¤j®v

½Ð°Ý¦p¦ó·f°t ¦¯³ø »P ¹A¾ä¤é´Á¡B¸`®ð
§Ú·Q°µ¤å¦r¤ÀªR¡A¦pªþ¥ó
ÁÂÁÂ
¤ÀªR¡G¥»¦¯¦Ü¤T¤ë¤G¤Q¤@¤é¨ì¤T¤ë¤T¤Q¤@¤é¡]¹A¾ä____¤ë____¤é¦Ü____¤ë____¤é¡^¡A¸`®ð¬°_____¡A¦@¥æ©ö¢°¢°¤Ñ¡A¸û«e¦¯¼W¥[¢°¤Ñ¡A
¤ÀªR¡G¥»¦¯¦Ü¤T¤ë¤G¤Q¤@¤é¨ì¤T¤ë¤T¤Q¤@¤é¡]¹A¾ä____¤ë____¤é¦Ü____¤ë____¤é¡^¡A¸`®ð¶i¤J_____¡A¦@¥æ©ö¢°¢°¤Ñ¡A¸û«e¦¯¼W¥[¢°¤Ñ¡A

¦¯§O§PÂ_0118.rar (20.08 KB)
¤å¦r»¡©ú
¤@¦~¦³12­Ó¤ë¡A¤@­Ó¤ë¦³¤À¤W¤¤¤U¦¯
©Ò¥H    ¤T¤ë¤¤¦¯¥H  ¼Æ¦r 32 ¥Nªí
            ¤­¤ë¤W¦¯¥H  ¼Æ¦r 51 ¥Nªí
            ¤C¤ë¤U¦¯¥H  ¼Æ¦r 73 ¥Nªí

¦^´_ 1# momo020608

¦bÄæ¦ì E18 ¿é¤J ¬Y¤ë¥÷ªº¤W¤¤¤U¦¯¥H¼Æ¦r¥Nªí¡A§Y¥i¦Û°Ê¥H¤å¦r¤ÀªR¡C

TOP

B1:B141=MONTH(A1)&LOOKUP(DAY(A1),{0,11,21},{1,2,3})
F2:F29{=IFERROR(INDEX(A:A,SMALL(IF(B$1:B$7000=$E$18,ROW(B$1:B$7000)),ROW(A1))),"")
°Ñ¦Ò~

TOP

B1:=MONTH(A1)*10+SUM(N(DAY(A1)>{0,10,20}))
F18:=IF(ROW(A1)>COUNTIF(B:B,E$18),"",INDEX(A:A,MATCH(E$18,B:B,)+ROW(A1)-1))

TOP

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


    ÁÂÁ¤j®a¡A§Ú¦A¨Ó¦n¦nªº·Q·Q

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD