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

[µo°Ý] ·P®¦¤j¤j­Ì §Æ±æ¥i¥H¨D¸Ñ ¶º©±±Æ©Ð°ÝÃD

[µo°Ý] ·P®¦¤j¤j­Ì §Æ±æ¥i¥H¨D¸Ñ ¶º©±±Æ©Ð°ÝÃD

½Ð°Ý¦U¦ì¤j¤j

§Æ±æ¥i¨D¸Ñ

·P®¦·P®¦¦A·P®¦
¦p¹Ï

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

¦^´_ 23# tr24572411

D11 =IF(B11="","",IF(C11<>"",C11,LOOKUP(SUMPRODUCT((B$10:B10=B11)*(C$10:C10="")),SUBTOTAL(9,OFFSET(P$10,,MATCH(B11,Q$10:X$10,),ROW($1:$160))),P$11:P$13)&""))

AG11 ¤½¦¡¦A­«·s½Æ»s¨ì°Ï°ì
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 22# ML089


    ML089¤j¤j±z¦n
¦]¬°®æ¦¡§Ú³£¦³­×§ï¹L  ¦ý¬O³sµ²¤@¨Ç¸ê®Æ©Î¤½¦¡«á
¥X²{¤@¨Ç°ÝÃD?
·Q½Ð°Ý
1.½Ð°Ý¦p¦ó­×§ï¦¨ ·íBÄ欰ªÅ¥Õ®É ¨Ã¤£¼vÅTDªº­È  ¥uÅã¥ÜªÅ¥Õ©O?
2.AB11Äæ¦ìªº¥þ³¡©Ð¸¹ªí Åã¥Ü¿ù»~?
¬¡­¶Ã¯1.rar (148 KB)
ÁÂÁ±zªº¤j¤OÀ°¦£
lo

TOP

¦^´_ 21# ML089

20160516ª©AMOKAT4.rar (122.23 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-5-16 16:58 ½s¿è

¦^´_ 20# tr24572411

AD4 =­ì©l»Ý¨Dªí«¬ºA!E2&""
D10 =IF(C10<>"",C10,LOOKUP(SUMPRODUCT((B$9:B9=B10)*(C$9:C9="")),SUBTOTAL(9,OFFSET(P$3,,MATCH(B10,Q$3:X$3,),ROW($1:$274))),P$4:P$9)&"")

Q4 =MIN(SUM($G4:G4)-SUM($P4:P4),SUM($Q$2:Q$2)-SUM($Q$3:Q3)-SUM($P4:P4),Q$2-SUM(Q$3:Q3))
v4 =MIN(SUM($L4:L4)-SUM($U4:U4),SUM($Q$2:V$2)-SUM($Q$3:V3)-SUM($P4:U4),V$2-SUM(V$3:V3))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 19# ML089

·PÁ¤j¤jªºÀ°§U ¹ï§ÚÀ°§U¯uªº«Ü¤j
§Ú±N±zªº¤½¦¡®M¥Î¨ì¦Û¤v»Ý­nªºÀɮפ¤
¦³¥X²{¤j¶q¸ê®Æ®É ¥X²{°ÝÃD
½Ò¤H¸ê®Æ LIM YAN «á¸ê®Æ¥þ³¡µLªk³B²z
¤wªþ¤WÀÉ®×
¥ý¦A¦¸·PÁ±zªºÀ°§U
ÁÂÁÂ
    20160516¥X²{°ÝÃDª©.rar (175.98 KB)
lo

TOP

¦^´_ 16# tr24572411

­×§ï¤À°t¼Æ¤½¦¡¤Î¤@¨Ç»¡©ú¡A¸ÔÀɤº»¡©ú

20160515ª©AMOKAT3.rar (54.54 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 16# tr24572411

¼W¥[¡A±N§Aªº®æ¦¡Âà´«¬°¦Û°Ê±Æ©Ðªí®æ®æ¦¡
    20160515ª©AMOKAT2.rar (42.77 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-5-15 11:54 ½s¿è

¦^´_ 16# tr24572411

¤â°Ê+¦Û°Ê¬¡­¶¤¤¡A»Ý¨Dªí¬OªÅªº
§A¦bM4¿é¤J1¡AD14´N·|¥X²{¤p¤ý3¡A
§A¦bM5¿é¤J1¡AD15´N·|¥X²{¤p¤ý3¡A
¤@ª½©¹¤U¿é¤J¥iÆ[¹î¦Û°Ê±Æ©Ðªº®ÄªG

³o¤@§å­q©Ð¿é¤J(G4:N9)§¹¦¨«á¡ADÄæ´N·|±Æ©Ð§¹¦¨
§A½T»{¨S¦³°ÝÃD«á
¦A½Æ»sDÄæ¶K­È¦ÜCÄæ¡A¨Ã²M°£»Ý¨Dªí¡Aµ¥¤U¤@§å­q©Ð¦A¿é¤J¡C

20160515ª©AMOKAT.rar (35.47 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 15# ML089


    ·PÁÂ"ML089"ªºÀ°§U
   ¦ý§Ú¤U¸ü«á ¤u§@ªí"¤â°Ê+¦Û°Ê"¤ºDÄæ¨Ã¤£·|¦]¬°»Ý¨Dªí¦Ó¸òµÛÅÜ°Ê
  ¦]¦¹µLªk¥h²z¸Ñ±zµ¹ªº·N¨£ ©Î¬O§ÚEXCEL¦³³]©w¤Wªº°ÝÃD
¨Ã¦A¦¸ªþ¤W  ¹ê»Ú»Ý­nªºªí®æ«¬ºA  
¨Ã½Ð¦U¦ì¤j¤j Åwªï«ü±Ð  ·P®¦ ·PÁÂ
ÁÂÁÂ
20160515ª©.rar (23.36 KB)
lo

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD