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

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

¦^´_ 10# ML089
·PÁ¤j¤jªº¦^ÂÐ

¤é´Á¦]¬°Á{®É¶ñ¤Jªº¡A©Ò¥H­«½Æ¨ì¤F
¥¿±`À³¸Ó¬O 2007/8/22 : 2007/8/31 ¨S¿ù

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2018-8-15 14:44 ½s¿è

¦^´_ 11# jackson7015

D48:AG48 ¬° 2007/9/1 : 2007/9/30
BV48:CE48 ¬° 2007/8/22 : 2007/8/31 ­ìÀÉ®×­n­×¥¿


D50®æ¦¡¤Æ¤½¦¡¡A¾Ü¨ä¤@¨Ï¥Î   
=COUNT(0/(($D$48:$CE$48<=D$48)*($D$48:$CE$48>D$48-7)*($D50:$CE50=CHOOSE(ROW($1:$3),5,6,11))))
=COUNT(0/(($D$48:$CE$48<=D$48)*($D$48:$CE$48>D$48-7)*(($D50:$CE50=5)+($D50:$CE50=6)+($D50:$CE50=11))))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# ML089
·PÁ ML089 ª©¥D¤j¤jªº¤£§[¦^´_

¤½¦¡¥i¥H¥¿±`§PÂ_"·í¤ë"ªº³¡¤À
´ú¸Õ«e¤ë¥÷ªº§ó°Ê¯Zªí«á¡A¨S¦³³s°Ê¨ì·í¤ë¥÷ªº§PÂ_¤½¦¡
¦Ó¤½¦¡¦b®æ¦¡¤Æ¤½¦¡ªº§PÂ_¤W¤]¬Û¤Ï(³o®e©ö¸Ñ¨M)

¬O§_¥i¥H¦A³Â·Ð¤j¤j¬Ý¬Ý¡A·P¿E¤£ºÉ

TOP

¦^´_ 13# jackson7015


    ´ú¸Õ«e¤ë¥÷ªº§ó°Ê¯Zªí«á¡A¨S¦³³s°Ê¨ì·í¤ë¥÷ªº§PÂ_¤½¦¡
³o¥y¤£¬O«ÜÀ´
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 14# ML089

©êºp¡A­è­è¦b­«·s´ú¸Õ¤F´X¦¸¡Aµo²{¤½¦¡¥¿±`µL»~

¦ý¬O¦]¬°¨Ï¥Î¦b®æ¦¡¤Æ¤¤­n¦A¥X²{"5.6.11"®É¬OFALSEªº§P©w
©Ò¥H®æ¦¡¤Æ¤½¥Ü§ï¦¨
D50=NOT(COUNT(0/(($D$48:$CE$48<=D$48)*($D$48:$CE$48>D$48-7)*($D50:$CE50=CHOOSE(ROW($1:$3),5,6,11)))))

µM«á¤S¦]¬°µL¤W¯Z®É¤]¥X²{°Ê§@¡A©Ò¥H¥u¦n¦b®æ¦¡¤Æ±ø¥óªí¤¤¦h¥[¤F
D50=IF(OR(LEN(D$48)<1,LEN($BU50)<1),TRUE,FALSE)
¥B¦bªí¦C¤¤ªºTURE¦¨¥ß´N¤£¦AÄ~Äò§P©w¤U¦¡

¦A¦¸·PÁÂML089¤j¤jªºÀ°¦£

TOP

¦^´_ 15# jackson7015

$BU50¡G¤W¤ë¤u§@¤Ñ¼Æ
D:I »Ý­n¤W­Ó¤ë¸ê®Æ¡AJ¥H«á´N¤£¥Î¤F¡A
®æ¦¡¤Æ±ø¥óªí¤¤¦h¥[¤F
D50=IF(OR(LEN(D$48)<1,LEN($BU50)<1),TRUE,FALSE)
·|¤£·|¦³¤Ï®ÄªG¡A·í LEN($BU50)<1 ®É¡AJ¥H«áªº§PÂ_¬O§_³Q¼vÅT
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 16# ML089

¥Ø«e´ú¸Õ J ¥H«áªº®æ¦¡¤ÆÁÙ¨S¦³¥X²{¼vÅTªº¼Ë¤l
¦]¬°¨ä¥LÀx¦s®æ¤]¦³«Ü¦h¸ê®Æ¡AÁÙ¨S¥X²{¿ù
¦pªG¦³¼vÅTªº¸Ü´N§â­ã´£³¡ªL ¤j¤jªº¤½¦¡®³¨Ó¥Î¦b¤C¤Ñ«áªº

¦ÓLEN($BU50)<1 ¬O¦]¬°¨ºÄæ¦C·|©ñ¤H¦W¡A©Ò¥H¥Î¨Ó§PÂ_¦³µL¤H­û¤Î¤W¯Z¤é
¼È®ÉÁÙ¨S¬Ý¥X¼vÅT..

¦Ó­è­è¤½¦¡¤W½u«á¡A¤]§ì¥X¤F¦³¶W7¥ð1ªº¤H­û
·PÁÂML089ª©¥DªºÀ°¦£~

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD