¦p¦ó¦bexcel¿é¤J¸ê°T«á·|Åã¥Üªº¥\¯à?
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-7-19
- ³Ì«áµn¿ý
- 2015-8-15
|
¦p¦ó¦bexcel¿é¤J¸ê°T«á·|Åã¥Üªº¥\¯à?
§Ú¬Oè·s¶iªºÜºÞ¤Hû.¦ý§ÚªºÜºÞ«D±`ªº¶Ã¤¤¦³§Ç
¦Ó§Úªº°Ï°ì¦a¹ÏÅã¥Ü¥u¬O´yz¤Fª««~ªº¤j·§¦ì¸m¨Ã«D¬O100%¥¿½T¦ì¸m
§Ú²{¦b·Qn°µ¤@Ó¿é¤J»PÅã¥Üªº¸ê°T¨Ó¼Ð©úª««~ªº¦ì¸m
³o¬O§Úªºµ¦¹º¤j·§
EXCELªºµe±
¡m-------------------------------------------------------------
excel¶}ÀY¬O¼ÐÃD
³o®Øn¤jªÅ¥Õ¬O¿é¤J§Ú¤½¥q§Ç¸¹ ³o¸Ì®Ø¬O¿é¤J«á©ÒÅã¥Üª««~¦ì¸m
¨Ò¦p:§Ç¸¹¬O T01KXXXXX A2032
A20¬O°Ï°ì 3¬O¦æ¼Æ 2¬O²Ä2¼h
³oÃä®Ø±¬O©T©w¤£Åܪºexcel®Ø¹Ïµe°Ï°ì
A01-3 A01-2 A01-1 ¨«¹D B01-1 B02-2 B03-3
A02-3 A02-2 A01-1 ¨«¹D B02-1 B02-2 B02-3
A03-3 A03-2 A03-1 ¨«¹D B03-1 B03-2 B03-3
¥H¦¹Ãþ±À.....
·í§Ú¿é¤J§¹§Ç¸¹«á ®Ø¹Ïµe°Ï°ìÅã¥Üª««~©Ò¦b
¦Ó§Úªº¹Ïµe°Ï°ì·|IJ°Ê¨ì®Ø¹Ïµe°Ï°ì¼Ð®Ø¦ì¸m
¹Ïµe°Ï°ìA05-2 ·|Åã¥ÜÃC¦â®Ø½u¼Ð¥Ü
----------------------------------------------------------------¡n
¤j¦Ü¤W´N¬O§Úªº¤j·§·Qªkªº°µªk...¬O§_¥i¥H±Ð§Ú¦p¦ó§@excel
¦n¹³§Úªº°µªk¬O¤£¬O·|²o§è¨ì¸ê®Æ®w???¦n¹³¬O
¨C¦ì¸m¤¤³£·|¦³«Ü¦hª««~A02-3´N¦³5ºØ§Ç¸¹.©Ò¥H¬O¤£¬OÁÙn°µ¸ê®Æ®w
ÁÙ¬OEXCEL¤w¸g¦³¶i¤Æ¤F...¥i¥H¦b·sªºÀÉ®×°µ¸ê®Æ®w???½Ð¹F¤H±Ð±ÂÁÂÁÂ...
§Ú¥u·|°µ°ò¥»ªº¹Ï±.§Ú¥u¬O·Q°Ýn«ç»ò°µ¿é¤J«áÅã¥Ü...½Ð¹F¤H¨Ó±Ð±Ð§Ú |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2015-6-23
- ³Ì«áµn¿ý
- 2019-11-14
|
|
|
|
|
|
|
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-7-19
- ³Ì«áµn¿ý
- 2015-8-15
|
¦^´_ 2# dragonhsu
§Aªº°µªk¸ò§Ú®t¤£¦h....
¤£¹L....§A¤W±¥ªÃä§Ú¬On°µ¿é¤J§Ç¸¹«á...µM«á¥kÃä´N¬OÅã¥Ü¦ì¸m©Ò¦b
¦Ó¤U¤è·|¦³ÃC¦âªº®ØÅã¥Ü¦ì¸m¦bþ
¥u¬O§Ú¤£ª¾¹Dn«ç»ò°µ¡iA01-3¡j¸Ìªº§Ç¸¹¡A¬On°µ¸ê®Æ®w¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-7-19
- ³Ì«áµn¿ý
- 2015-8-15
|
¦^´_ 2# dragonhsu
´N¬O³o¼Ë°µ...¦ý§Ú´N¬O¤£·|°µ¡iA03-1¡jªºÁôÂçǸ¹
¬On°µ¸ê®Æ®w¶Ü??ÁÙ¬O¥i¥H¦bEXCEL«Ø¥ß¸ê®Æ |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2015-6-23
- ³Ì«áµn¿ý
- 2019-11-14
|
¥»©«³Ì«á¥Ñ dragonhsu ©ó 2015-7-23 09:22 ½s¿è
¦^´_ 4# king10302
¥u¬O§Ú¤£ª¾¹Dn«ç»ò°µ¡iA01-3¡j¸Ìªº§Ç¸¹¡A¬On°µ¸ê®Æ®w¶Ü?
ÁôÂçǸ¹¬O«ü¤°»ò ?
·í§A¿é¤J§Ç¸¹«á, ´N·|±a¥XÀx¦ì¨Ã©ó¨ºÓÀx¦ì¼Ð¥Ü¬õ¦â,
ÁÙ¬O§Aªº·N«ä¬O §Ç¸¹¥u¦³T01KXXXX, «á±¨S¦³ A2032ªº³oÓ¦r¦ê |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2015-6-23
- ³Ì«áµn¿ý
- 2019-11-14
|
|
|
|
|
|
|
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-7-19
- ³Ì«áµn¿ý
- 2015-8-15
|
¤£¦n·N«ä...³Ìªñ³£¦b¦£¥[¯Z¨ì¤µ¤Ñ°²¤é¤~¦³ªÅ
§Ç¸¹´N¬O§Ṳ́½¥q£x²£«~®Æ¸¹...¦Ó§Ú³]©wªºA03-5
¬O«ü®Æ¸¹T01K000006´N¬O¦bA03-5.·í§Ú¿é¤J¤F®Æ¸¹´N·|Åã¥ÜÀx¦ì©Ò¦b
¦]¬°ªF¦è¤Ó¦h»Ýn§ä..©Ò¥H§Ú¤~·Q«Ø¥ß¸ê®Æ©¹«á«K®e©ö´M§ä |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2015-6-23
- ³Ì«áµn¿ý
- 2019-11-14
|
¦^´_ 7# king10302
¦bdata base ªºsheet¸Ìn«Ø¥ß¥H¤Uªº¸ê®Æ
®Æ¸¹ Àx¦ì
T01K000001 A2032
T01K000002 B2021
T01K000003 A2011
T01K000004 A1031
T01K000005 A1111
T01K000006 A0112
T01K000007 A0938
¦bsheet1 ¸Ì
F2ªºÄæ¦ì¿é¤J=MID(VLOOKUP(B2,'Data base'!A2:B29,2,0),1,3)&"-"&MID(VLOOKUP(B2,'Data base'!A2:B29,2,0),4,1)
³]©w®æ¦¡¤Æ±ø¥óÅý¥L¤Ï¬õ
=B4=$F$2 |
|
|
|
|
|
|