¨DÀ°¦£¬Ý¤@¤U «ç»ò§ï¶i (·s¤â°ÝÃD)
- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ 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 |
|
|
|
|
|
|