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

[µo°Ý] ¤ñ¤j¤p&­«½Æ¨ú¨ä1ªº¨ç¼Æ¤½¦¡¡C

­n¤@¦¡¥þ³¡©Ô¨ì©³¡A»Ý­n±N¸ê®ÆÄæ¦ì¹ï»ô¡A¤£µM¤½¦¡·|¤S¯ä¤Sªø¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 10# ML089
Mª©¥D :±z¦n!
AQ3 :AR3  ¨â¦¡¤U©Ô =>µª®×¥¿½T
½Æ»s AQ3:AR7 ¦ÜAS3:AV7 =>AS3:AV7³£¸òAQ3:AR7 ¬Û¦P =>µª®×¤£¥¿½T
¸U¤À·PÁ±z¤@¦Aªº¼ö¤ß«ü¾É^^
===========================
Mª©¥D :
¬°¤FÅý(¶¶À³)¤½¦¡¦n½s¼g
¤£¤~±Nªí®æ·L½Õ­×§ï¦p¤U~
AP9°Å¤U¡A¶K¤WAP10
AP3:AP10ªºÀx¦s®æ¦¡§ï¬°=>¦Û­q=>"¦C"#
¸Ô¦pªþ¥ó : TSET_1.rar (16.52 KB)
ÂԽбz°Ñ¦Ò!
ÁÂÁ±z!±ß¦w^^

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2019-9-9 20:40 ½s¿è

¦^´_ 12# ziv976688

­è¦n¤»¤é³£¦³¨Æ¨S¦³¿ìªk¥ß§Y¦^ÂÐ
(1)
AQ3 =MAX(--TEXT(INDEX($B:$G,$AP3,),"[>="&IF(AO3,AO3,999)&"]!0"))
AR3 =INDEX($B:$G,2,MATCH(AQ3,INDEX($B:$G,$AP3,),))
½Æ»s AQ3:AR3
¶K¤W AQ4:AR7
½Æ»s AQ3:AR7
¶K¤W AS3:AV7

(2)
½Æ»s AQ3:AR3
¶K¤W¦U°Ïªº¥ª¤W¨¤Àx¦s®æ
±N¤½¦¡¤¤ªº $B:$G ­×§ï¬°
  ¤ì($H:$P)
  ¤ô($Q:$X)
  ¤õ($Y:$AF)
  ¤g($AG:$AN)                       

¦p(1) ½Æ»s¤Î¶K¤W ¸Ó°Ï¤½¦¡

(3) ·íµM¤½¦¡¤]¥i¥H¦Û°Ê§ì¨ú ²Ä¤@¦C¤¤¦p¤Uªº¤å¦r¡A§Q¥ÎINDIRECTÂର°Ï°ì¡A¦ý¤£»Ý¥I¥X¶Wªø¤½¦¡§@¬°¥N»ù¡A«Øij¥Î¤â°Ê­×§ï¤ñ¸û®e©öºûÅ@¤½¦¡¡C
  ª÷($B:$G)
  ¤ì($H:$P)
  ¤ô($Q:$X)
  ¤õ($Y:$AF)
  ¤g($AG:$AN)

¤ñ¤j¤p&­«½Æ¨ú¨ä1ªº¨ç¼Æ¤½¦¡(1).rar (20.29 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 13# ML089
Mª©¥D:
ÁÂÁ±zªº­@¤ß½ç±Ð!
¦³½d¨ÒÀɤè«K³\¦h~¤£¤~·|¦n¦n¬ã¨s~·P®¦........^^

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2019-9-11 10:43 ½s¿è

¦^´_ 14# ziv976688

(1)        AQ3 =MAX(--TEXT(INDEX($B:$G,$AP3,),"[>="&IF(AQ$1="",AO3,999)&"]!0"))
        AR3 =INDEX($B:$G,2,MATCH(AQ3,INDEX($B:$G,$AP3,),))
        °}¦C¤½¦¡

(2)        AQ3 =MAX(--TEXT(INDEX($B:$G,$AP3,),"[>="&IF(AQ$1="",AO3,999)&"]!0"))
        AR3 =SUBSTITUTE(TEXT(SUM(LARGE(IF(INDEX($B:$G,$AP3,)=AQ3,$B$2:$G$2,0),{1,2,3,4,5})*10^{0,2,4,6,8}),"00"&REPT("!,00",4)),"00,",)
        °}¦C¤½¦¡

(1)¦¡ªºAR7·|Åã¥Ü 21  (¼Æ¦r)
(2)¦¡ªºAR7·|Åã¥Ü 21,22 (¤å¦r)

¤ñ¤j¤p&­«½Æ¨ú¨ä1ªº¨ç¼Æ¤½¦¡(2).rar (20.94 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-9-10 23:52 ½s¿è

¦^´_ 15# ML089
ª©¥D:±z¦n!
±z¤Ó¼F®`¤F¡A¤Ó¯«¤F!
±N¤£¤~ªº³Ì²×¥Øªº³£¹F¦¨¤F!·P®¦.........^^

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-9-12 03:32 ½s¿è

¦^´_ 15# ML089
´ú¸ÕÀÉ : «e3¤j§ï«e3¤pªº¤½¦¡.rar (24.65 KB)
Mª©¥D:±z¦n!
«Ü©êºp!¦]¬°¶Q¤½¦¡¶W°ª¶¥¡A¤w¶W¶V¤£¤~¯à²z¸Ñªº½d³òN¦h¡A©Ò¥H¤£¤~¸Õ§ï¤Fªñ¤@¤Ñ¡A²×¬O¨SÂá^^///(¦½ÃC)

«_¬N¦A½Ð°Ý :
ªÅ¼Æ«e3¤p!AQ3:BC8ªº«e3¤j¤½¦¡((2)¦¡)­n¦p¦ó§ï¬°«e3¤pªº¤½¦¡?
¸Û½Ð±z½ç±Ð!ÁÂÁ±z^^

TOP

¦^´_ 17# ziv976688

¨ú¤j¦Ü¤p
AQ3 =MAX(--TEXT(INDEX($B:$G,$AP3,),"[>="&IF(AQ$1="",AO3,999)&"]!0"))

¨ú¤p¦Ü¤j
AQ3 =MIN(--TEXT(INDEX($B:$G,$AP3,),"[<="&IF(AQ$1="",AO3,-1)&"]!9!9"))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 18# ML089

Mª©¥D:±z¦n!
·PÁ±z©âªÅ¦^ÂÐ^^
AQ3=> OK¤F!
AR3ªºµª®×¤]·|¸òµÛ¹ïÀ³§ó°Ê¦¨¬°"«e3¤p"(«Ü¯«^^)

½Ð°Ý¤@¤U:
¬°¤°»òAQ3:AV3¤U©Ô¨ìAQ8:AV8
AQ3:AV7¥þ³¡¥¿½T¡AAQ8µª®×¤]¥¿½T¡A
¦ýAS8©MAU8µª®×¤£¥¿½T¡C

¦P²z
AX3:BB7¥þ³¡¥¿½T¡AAX8µª®×¤]¥¿½T¡A
AZ8©MBB8µª®×¤£¥¿½T¡C
¸Û½Ð±z¦A¦¸«ü±Ð!ÁÂÁ±z^^

´ú¸ÕÀÉ : «e3¤j§ï«e3¤pªº¤½¦¡(0912).rar (24.42 KB)

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-9-13 00:53 ½s¿è

¦^´_ 18# ML089

Mª©¥D:±z¦n!
ÁA¸Ñ¤£¤~¦b19¼Óªº°ÝÃD¬O¥X¦b­þ¸Ì¤F^^
¬O¦]¬°52¦Cªº²Ä1¤p¶W¹L99¤F¡C
±N¤½¦¡¤¤ªº"!9!9"§ï¬°"!99!9"©Î"!99!99"´N¥i¥H¤F¡C

¦ý¦]¦¹¤S²£¥Í¤@­Ó¤p°ÝÃD~
¦]¬°¦¸¼ÆªºÅã¥Ü­È9999¡A·|Åý¤ñ¤j¤pªº§@¥Î¥¢¯u¡A©Ò¥H¬O§_¯à¤£­nÅã¥Ü"9999"¡A¦Ó¯àÅã¥Ü"0"¡A
·íµM¯àÅã¥Ü"ªÅ¥Õ"¬O³Ì¦n¤£¹L¤F~¦ý¤£´±±j¨D¡A¥]¬A«e3¤jªº¦¸¼ÆÅã¥Ü"0"¯à§ïÅã¥Ü"ªÅ¥Õ"¥ç¦P¡C
EX : °²³]±NB9:G9¥þ³¡§ï¬°18¡A«hAS3=0¡FAU3=0©ÎAS=""¡FAU3=""

¤£¦n·N«ä¡A°ÝÃD¤@°ï¡A¸Û½Ð¨£½Ì! ÁÂÁ±z^^"

¯¬±z : ¤¤¬î¸`§Ö¼Ö!

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD