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

AÄæ³Ì«áA65536 ­Ë±Àªº²Ä¤@­Ó¦³¸ê®ÆªºÀx¦s®æ

AÄæ³Ì«áA65536 ­Ë±Àªº²Ä¤@­Ó¦³¸ê®ÆªºÀx¦s®æ

¶Ç¦^AÄæ³Ì«áA65536 ­Ë±Àªº²Ä¤@­Ó¦³¸ê®ÆªºÀx¦s®æ
¤½¦¡¦p¦ó¼g??

¼g¤°»ò¼g
AÄæ¥ô·N¿ï¨úÀx¦s®æ§ÖÂI2¤U

ÂI¨º¸Ì?
¤W®Ø½u
¤U®Ø½u
¥ª®Ø½u
¥k®Ø½u
¤¤¶¡
¥k¤U¨¤

¨ì©³§P ...
¦Ñ®L µoªí©ó 2011-6-9 11:08

§PÂ_ a65536 ,a65535,a65534 .............ª½¨ì«DªÅ¥Õ¬°¤î

TOP

lookup(9^9,a:a)

TOP

i = Worksheets("sheet1").Cells(65536, 1).End(xlUp).Row

¶Ç¦^AÄæ³Ì«á¤@µ§¸ê®ÆªºÄæ¦ì
GinBow

TOP

i = Worksheets("sheet1").Cells(65536, 1).End(xlUp).Row

¶Ç¦^AÄæ³Ì«á¤@µ§¸ê®ÆªºÄæ¦ì
ginbow µoªí©ó 2011-6-9 15:04


¬O¤½¦¡¤£¬O¥¨¶°

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-6-14 17:50 ½s¿è

¦^´_ 5# t8899
=LOOKUP(2,1/(A:A<>""),ROW(A:A))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# t8899


    =LOOKUP(65536,A:A,ROW(A:A))
£«§g

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD