ªð¦^¦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 : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD