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

[µo°Ý] ½Ð±Ð¤é´ÁªºMatch°ÝÃD

[µo°Ý] ½Ð±Ð¤é´ÁªºMatch°ÝÃD

¦p¸ê®ÆÄ欰¤é´Á®æ¦¡:
A1  2012/1/1
A2  2012/1/31
A3  2012/2/2
A4  2012/2/5

AÄæ·Ó®É¶¡±Æ§Ç , §Ú·Q¥Îmatch§ä¤j©ó©Îµ¥©ó 2012/2/1ªºÄæ¦ì¥i¬O³£·|¥X¿ù
rIndex = Application.Match(CLng(DateSerial(2012, 2, 1)), [A1:A4], -1)
1. °£¤F°j°é¥~ , ¦³¤ñ¸û²³æªº¤èªk§ä¶Ü?

2. ¦pªG¤£¥ÎVBA , §ï¥Î¤½¦¡¸Ó«ç»ò§ï?

¦^´_ 1# stillfish00
¦Û¤v¦^¦Û¤v~~
­ì¨Ó¦Û¤v¦³ª¼ÂI , Matchªº²Ä¤T­Ó°Ñ¼Æ¬°-1®É , ­n¨D°Ñ¼Æ2¶·¥H»¼´î¶¶§Ç±Æ¦C
¤@ª½³£¨Sª`·N¨ì³oÂI....

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD