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

¨DÀ°¦£¬Ý¤@¤U «ç»ò§ï¶i (·s¤â°ÝÃD)

¨DÀ°¦£¬Ý¤@¤U «ç»ò§ï¶i (·s¤â°ÝÃD)

¥»©«³Ì«á¥Ñ ¥d¹Å¶ð ©ó 2014-4-16 08:53 ½s¿è


´N¯à¸ó¦æ¦X¨Ö¶Ü? ¦P¤½¥qªºÃþ§O¦X¨Ö°_¨Ó
¥Ø«e¦³·Q¨ì¤@­Ó¿ìªk ¥i¬O·Pı¦³¨Ç©Ç©Ç ¦Ó¥B¦X¨Ö¤ºªº¦P¼ËÃþ§OµLªk§ì¥X ¤ñ¦p:["1"]["1"]

©³¤U³o¹Ï ¬O§Ú·Q¥X¨Óªº¤èªk

§Ú¬O¥ý§ì¥X¨Ì§Ç­«½Æªº µM«á¦A¦X¨Ö
¥i¬O¥L³s©³¤Uªº¤]·|§ì¨ì ©Ò¥H³Ì«á¦b¨ú²Ä¤@­Ó
-------------------------------------------------
§xÂZ¤§¤@

§ÚµLªk§ì¥X¦X¨Ö¤º¦P¼ËÃþ§O   ¤ñ¦p:["1"]["1"]["3"]
¥¿±`¬O["1"]["3"]

§xÂZ¤§¤G

­n¬O­«½Æ¦¸¼Æ¶W¹L4¦¸¥H¤W ´N·|§ì¤£¨ì ¥i¬O§Ú¤£¤Ó¥i¯à¤@­Ó¤@­ÓÀ˹î...²¦³º¥¿¦b§@ªº¦³´X¸Uµ§....

----------------------------------------------------------
¦³¤H¦³§ó¦nªº¿ìªk¶Ü?

¥»©«³Ì«á¥Ñ p212 ©ó 2014-4-16 10:28 ½s¿è

¦^´_ 1# ¥d¹Å¶ð
1¡B¥ý©w¸q¦WºÙ
x =OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$D:$D)+1,)
y =FREQUENCY(ROW(x),IF((x<>"")+(ROW(x)=(COUNTA(Sheet1!$D:$D)+1)),ROW(x),""))

2¡B¦A©óÀx¦s®æE2¿é¤J¤@¯ë¤½¦¡
=IF(A2="","",PHONETIC(OFFSET(D2,,,INDEX(y,COUNTA($A$2:A2)+1))))
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

¥H¤W¸Ñªk°Ñ·Ó¶W¯Åª©¥DHsieh¤§«ü¾É(°Ñ¨£¤U¦Cºô§}¤§6#¡B7#)
http://forum.twbts.com/viewthrea ... AFB%B0%CA%A6C%BC%C6

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2014-4-16 18:04 ½s¿è

¦^´_ 1# ¥d¹Å¶ð

E2 =IF(B2="","",PHONETIC(OFFSET(D2,,,LOOKUP(C2,C2:C19,ROW($1:$99)))))
¤U©Ô


$1:$99 : ªí¥Ü³Ì¦h 99²Õ¦X¨Ã¡A­Y¦³»Ý­n¤]¥i§ï¬° $1:$999
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD