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

[µo°Ý] ¤½¦¡Âà¤Æ¬°µ{¦¡»yªk¡C

¦^´_ 9# joblyc017

J¤j:
ÁÂÁ±zªº¤£§[«ü¾É^^

TOP

¦^´_ 8# papaya


   

TOP

¦^´_ 7# joblyc017

½d¨ÒÀÉ
TEST.rar (5.29 KB)
½Ð°Ñ¦Ò!ÁÂÁ±z^^

TOP

¦^´_ 6# papaya


    ½Ð´£¨Ñ½d¨ÒÀÉ¡AÁÂÁÂ

TOP

¦^´_ 5# papaya
SHEE2ªº¼Ðªº Äæ§Ñ¤F¼Ð¥Ü~¸É¤W

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2017-11-22 05:25 ½s¿è

¦^´_ 3# joblyc017
j¤j:
¤£¦n·N«ä¡A¯à§_¦A½Ð±z«ü¾É~
·í"DK7:DK"&COUNT(DK:DK)+3¤§½d³ò¤º=$DK$4ªº¦C¡A¨ä¸Ó¦C·íÄæ©M¥kÃ䪺¤GÄæ¼Ð¥Ü8¸¹©³¦â¡C
½Ð°Ý:¤½¦¡Âà¤Æ¬°µ{¦¡»yªk­n¦p¦ó½s¼g?

¥t~
±N"DK7:DK"&COUNT(DK:DK)+3¤§½d³ò¤º=³Ì¤j¼Æªº¦C¡A¨ä¸Ó¦C·íÄæ©M¥kÃ䪺¤GÄæ¼Ð¥Ü8¸¹©³¦â¡C
½Ð°Ý:¤½¦¡Âà¤Æ¬°µ{¦¡»yªk­n¦p¦ó½s¼g?
ÁÂÁ±z^^

PS: "DK7:DK"&COUNT(DK:DK)+3ªº­È¡A¤£·|­«½Æ¡A¤¤¶¡¤]¤£·|¦³ªÅ¥Õ®æ¡C





¥u­nSHEET1§Y¥i¡ASHEET2¥u§@»²§U»¡©ú¥Î¡C

TOP

¦^´_ 3# joblyc017
ÁA¸Ñ¤F~
,,4  ­ì¨Ó4Ä檺½d³ò¥²¶·¥H .Resize(, 4)¨Óªí¹F¡C
ÁÂÁ±z^^

TOP

¦^´_ 2# papaya
  1. [C1] = Application.SumIf(Range("I1").Offset(Range("C2") - Range("B2") + 1, 1).Resize(, 4), Range("A1"), Range("D1").Offset(Range("C2") - Range("B2") + 1, 1).Resize(, 4))
½Æ»s¥N½X

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2017-11-21 11:38 ½s¿è

ª¦¤å³\¤[~¸Ñ¨M¤F~C2
[C2] = Application.Index(Range("D:D"), Application.Match(Range("A2"), Range("I:I"), 0))

¦ýC1ÁÙ¬OµLªk¸Ñ¨MQQ
https://support.microsoft.com/zh-tw/help/291308/how-to-select-cells-ranges-by-using-visual-basic-procedures-in-excel
¦]¬°¹ê¦bµLªk¥Ñ¤W­zºô¯¸ªº»¡©ú¤Î½d¨Ò¤¤§¹¥þ²z¸Ñ©M®M¥Î¦bC1¤½¦¡

Àµ½Ð¦U¦ì°ª¤â¤£§[½ç±Ð©M«ü¾É!ÁÂÁÂ¥ý!

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD