¨DÀ°¦£¬Ý¤@¤U «ç»ò§ï¶i (·s¤â°ÝÃD)
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¥»©«³Ì«á¥Ñ 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¨Ã¡AY¦³»Ýn¤]¥i§ï¬° $1:$999 |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|