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

[µo°Ý] ¦h±ø¥óªºVLOOPUP

¤£¥ÎVBA¤]¥i¥H, H~OÄæ爲»²§UÄæ, µª®×¦bQ~SÄæ


ªþ¥ó»Ý­n¥ÎWinRAR V5.0¤~¯à¶}啓
Sonny.rar (13.45 KB)














¦^´_ 4# ML089
¦^´_ 5# missbb
¦^´_ 6# nissin
¦^´_ 10# Hsieh
ss

TOP

¦^´_ 11# sunnyso

Sonny.gif
ss

TOP

¦^´_ 1# missbb
¦^´_ 11# sunnyso

«D³W«h¸ê®Æ·|Åý¤½¦¡½ÆÂø¤Æ¡A
¦³®É«D³W«h¸ê®Æ¬OÅý¸ê®Æ¬üÆ[¡A¥i¼W¥[»²§UÄæ¾ã²z¦¨¼Ð·Ç¸ê®Æ¶ô¡A¤]¥i¥Î²³æ¤½¦¡§¹¦¨¡C



F2
=SUMPRODUCT((F$1=LOOKUP(ROW($2:$7),ROW($2:$7)/($A$2:$A$7<>""),$A$2:$A$7))*
(--($E2&"1¤é")>=--(LEFT($B$2:$B$7,FIND("-",$B$2:$B$7&-1)-1)&"1¤é"))*
(--($E2&"1¤é")<=--(LEFT($B$2:$B$7,5)&SUBSTITUTE(SUBSTITUTE(RIGHT($B$2:$B$7,3),"-",),"¦~",)&"1¤é")),$C$2:$C$7)

¥k©Ô¤U©Ô½Æ»s¤½¦¡(¶À¦â°Ï)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 13# ML089


EXCEL¯u«YÅܤƦhºÝ, ·|¸Õ¸Õ¬Ý!¦hÁ¦U¦ì¤j¤j!:D

TOP

EXCEL¤dÅܸU¤Æ¦A¥[¤WVBA¦³±o¾ÇÅo

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD