- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 15
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-12
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2014-8-31 06:38 ½s¿è
¸g±`¿é¤J¦a§}®É»Ýn¬d¸Ó¦a§}ªº¶l»¼°Ï¸¹¡Aı±o«Ü³Â·Ð¡A
²{¤w¦³¦a°Ï¤Î¶l»¼°Ï¸¹¹ï·Óªí¡A·í¿é¤J¦a§}®É¦Û°Êvl ...
newlink µoªí©ó 2014-8-30 23:10
1. ¬JµM§A¤ñ¹ïªº°ò·Ç¬OLEFT(E2,5),
¨º»ò§Aªº¹ï·Óªí¤º®e´N³£¥u¯à¬O 5 Ó¤¤¤å¦r,
¦]¬° VLOOKUP ªº¤ñ¹ï¬O §¹¥þ ¤å¦r¤ñ¹ï¦Ó«D ³¡¤À ¤å¦r¤ñ¹ï.
§Y«K§A¨Ï¥Îªñ¦üȤñ¹ï¤]½Ð±N ¹ï·Óªí ¥þ³¡³£§ï¬° 5 Ó¤¤¤å¦r,
³o¼Ëµ²ªG¤~·|¥¿½T.
2. ¤½¦¡§An§ï¦¨ =IF(E2="","",VLOOKUP(LEFT(E2,5),$A$2:$B$100,2,0)) ¤~¥i¥H,
Range_lookup ÅÞ¿èÈY³]¬° 1 ©Î True ®Éªº¤ñ¹ï¬O ªñ¦üÈ ¤ñ¹ï,
¦Ó¥B§Aªº ¹ï·Óªí ¥²¶·¬O¸g¹L »¼¼W±Æ§Ç ¹Lªº, (¤]´N¬On¥Î ¦a°Ï ¬°ÁäÈ, °µ »¼¼W±Æ§Ç )
³o¼Ë¥X¨Óªºµ²ªG¤~·|¬O¥¿½Tªº.
¶l»¼°Ï¸¹¦Û°Ê¿é¤J-a.zip (9.27 KB)
¨Ï¥Îªñ¦üȤñ¹ïÁÙ¦³Ó¯ÊÂI,
¨º´N¬O´Nºâ§ä¤£¨ì²Å¦Xªº¸ê®Æ,
¥¦·Ó¼Ë·|µ¹§A¤@ӼƾÚ,
³o¼Ë´N¨S¦³ÀËÅç¸ê®Æ¥¿½T©Êªº¥\¯à¤F.
³Ì«á, ³o¸Ì¬O°Q½× Excel VBA µ{¦¡ªºª©,
µo¦b Excel ¤@¯ë°Ï ¤ñ¸û²Å¦X°Q½×ª©¥»¨¥DÃDªº»Ý¨D. |
|