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

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

¦^´_ 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

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

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

¦^´_ 3# sklo


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

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

¦^´_ 1# chiata

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

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD