papaya

¦^´_ 9# joblyc017

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

joblyc017

¦^´_ 8# papaya


   

¤U¸ü (89.19 KB)

2017-11-22 12:24

papaya

¦^´_ 7# joblyc017

½d¨ÒÀÉ
TEST.rar (5.29 KB)

¤U¸ü¦¸¼Æ: 5

2017-11-22 11:59

½Ð°Ñ¦Ò!ÁÂÁ±z^^

joblyc017

¦^´_ 6# papaya


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

papaya

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

¤U¸ü (148.06 KB)

2017-11-22 05:40

papaya

¦^´_ 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¸ü (158.7 KB)

2017-11-22 05:17

¤U¸ü (156.54 KB)

2017-11-22 05:21

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

papaya

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

joblyc017

¦^´_ 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

papaya

ª¦¤å³\¤[~¸Ñ¨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«ü¾É!ÁÂÁÂ¥ý!