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

[µo°Ý] ¦p¦óÂê©w¸ê®Æ³Ì«á¤@µ§?

[µo°Ý] ¦p¦óÂê©w¸ê®Æ³Ì«á¤@µ§?

CÄæ¸ê®Æ·|¤£Â_§ó·s¡ADÄæ¸ê®Æ¬°CÄæ¸ê®Æ²Ö­p¾ã²z¡A
·Q©T©w¦bA1Åã¥Ü³Ì«á²Ö­p¸ê®Æ¡A¥Ø«e·Q¨ìªº§@ªk¬O¥Îoffset»Pcounta¥h°µ¡A¦p¹Ï¡C
½Ð°Ý¦U¦ì«e½ú¦³¨S¦³§ó²¼ä©öÀ´ªº¤èªk¡AÁÂÁ¡C

¦^´_ 1# chiata

=PHONETIC(OFFSET(C1,,,COUNTA(C:C),))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§A¦n¡AHsieh¶W¯Åª©¥D

¬°¤°»ò§Ú¦bEXCEL¸Ì°µ¤£¨ì¼Ó¥D­n¨Dªº®ÄªG(¨£ªþ¹Ï)¡H¬OEXCELª©¥»°ÝÃD¶Ü¡H(§Ú¥ÎEXCEL 2007 ­^¤åª©)

ÁÂÁ¡I

a.jpg (32.21 KB)

a.jpg

TOP

¦^´_ 3# sklo


    2003¦³³o¦U¨ç¼Æ
   §Ú¨S¨Ï¥Î2007´N¤£ª¾¹D¬O¤£¬O¨S¦³
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¥»©«³Ì«á¥Ñ chiata ©ó 2013-1-28 15:35 ½s¿è
¦^´_  chiata

=PHONETIC(OFFSET(C1,,,COUNTA(C:C),))
Hsieh µoªí©ó 2013-1-28 14:00




©êºp¡A§Ú¨S»¡²M·¡§Úªº°ÝÃD...

CÄæ¬O¤£Â_§ó·sªº¸ê®Æ¡ADÄæ¬O¸ê®Æ²Ö¿n¾ã²z(¥i¯à·|¦b¨Cµ§¸ê®Æ¤¤¥[¤@¨Ç²Å¸¹)¡A³Ì«á§Æ±æA1ªº¸ê®Æ·|¹³D4¨º¼Ë¡A
¤£¹L¦]¬°¸ê®Æ§ó·s«á³Ì«á¤@µ§´N¤£·|¬OD4¡A©Ò¥H¤£¯àª½±µ¦bA1ªº¤½¦¡¿é¤J=D4¡C
§Ú¨Ï¥Î=ADDRESS(COUNTA(D:D),4)¥i¥H§PÂ_¥X³Ì«á¤@µ§¸ê®ÆªºÀx¦s®æ¦ì¸m¡A¦ý¨S¿ìªk³s¨ì¥¦ªº­È¡C

PS:ª©¥»¬OEXCEL 2000¡A¥i¥H¥¿±`¨Ï¥ÎPHONETIC¨ç¼Æ¡A²Ä¤@¦¸¬Ý¨ì¦¹¨ç¼Æ¡AGOOGLE¤F¥Îªk¡Chttp://isvincent.pixnet.net/blog/6

123.jpg (43.39 KB)

123.jpg

TOP

§Ú¸Õ¹L2010ªº¤]¥i¥H³á~
Adam

TOP

¦^´_ 5# chiata

³o¼Ëªº¸Ü¨Ï¥ÎOFFSET¬O³Ì²³æªº°µªk¤F
³»¦h¬O§â­ìÂI©w¦ì¦bD1¡A¬Ù²¤cols°Ñ¼Æ
=OFFSET(D1,COUNTA(C:C)-1,)
­Y¥ÎLOOKUP·íµM¤]¯à°µ¨ì¡A¤£¹L®£©È§ó¤£®e©ö²z¸Ñ¨ç¼Æ
=LOOKUP(2,1/(C1:AC5535<>""),D1:D65535)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

PHONETIC()¤£¾A¥Î©ó§t¦³¼Æ¦rªºÀx¦s®æ¡C¥i¥[¸É§UÄæ
D1=IF(ROW(A1)=1,C1,INDIRECT("d"&ROW(A1)-1)&";"&INDIRECT("c"&ROW(A1)))

TOP

¦^´_ 8# ANGELA

ÁÂÁ¦U¦ì«e½ú¡A¬Ý¨ÓOFFSET¤ñ¸û²³æ»P®e©ö²z¸Ñ¡C
=INDIRECT(ADDRESS(COUNTA(D:D),4))¤]¥i¹F¨ì¬Û¦P®ÄªG¡C

TOP

¦^´_ 9# chiata


½Ð°Ý³o¼Ë¥i¥H¹F¨ì±z·Q­nªº®ÄªG¶Ü?

=INDEX(D:D,COUNTA(D:D))

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD