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

[µo°Ý] ¦³Ãö©óexcel ¤½¦¡¦p¦ó³]©w.......

[µo°Ý] ¦³Ãö©óexcel ¤½¦¡¦p¦ó³]©w.......

¦U¦ì¤j®v¸t¤Hªø½ú¤j®a¦n¡G

¤p§Ìªñ¨Ó¦bexcel ¤è­±¦³ÂI°ÝÃD·Q½Ð±Ð¦U¦ì¦p¦ó³]©w¤½¦¡¡A§Ú­n­pºâ¨Ó·½¤@¡B¤G¡B¤T¤Î¥|ªº¦U­ÓÁ`©M¡A¤À¶}­pºâ¥X¨C­ÓÁ`©M³o­Ó³¡¥÷§Ú¤w¸g§Ë«Ü¦h¤Ñ³£§ä¤£¨ì­n«ç»ò³B²z¤ñ¸û¦n¯uªº¬O§Ö·Ð¦º¤F¡A¤£ª¾¹D¬O¨Ï¥Î if ÁÙ¬O vlookup¡A¥i¯à¬O­þÃä¨S¦³³]©w¨ìÁÙ¬O­n¼g»yªk³o­Ó³¡¤À¤£¤Ó²M·¡¡A³Â·Ð½Ð¨D¦U¦ì¹F¤HÀ°¦£ÁÂÁÂ~~

§Ú±N°µ¨ì¤@¥bªºexcelÀɮשñ¦b³oÃä¡G
https://drive.google.com/file/d/0BzlfqCNJbRKsS3lxYThfWEZlZ2c/edit?usp=sharing

§Æ±æ¦³½t¤H¯àÀ°¦£³B²z³o­Ó°ÝÃD¡AÁÂÁ¡I
§Úªº«H½c¬O¡G[email protected]


³Â·Ð¦U¦ì¤FÁÂÁÂ~~

¦^´_ 1# johnmanser


¦p¥u·Q­p¦U­Ó¨Ó·½Á`µ², ¥ÎSIMIF§Y¥i.

test.jpg (43.24 KB)

test.jpg

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD