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

[µo°Ý] Àx¦s®æÅã¥Ü¤è¦¡­«½Æ¨ì¤½¦¡ ¨D¸Ñ

[µo°Ý] Àx¦s®æÅã¥Ü¤è¦¡­«½Æ¨ì¤½¦¡ ¨D¸Ñ

¥»©«³Ì«á¥Ñ tr24572411 ©ó 2017-4-12 15:01 ½s¿è

¥ýÁÂÁ¤j¤j


¦p
¦]¬°¦¹¤u§@ªí¬°³sµ²¥~³¡Àɮ׬°¥D

©Ò¥HÀx¦s®æ¤@©w¦³¤½¦¡¦s¦b®É´N·|»PÀx¦s®æ±ø¥ó¦³©Ò½Ä¬ð
¦ý·Q¤u§@ªí¦³¸ê®Æ®É¤~Åã¥Ü¥~®Ø(¨Ò¦pH61¦ì¸m)(¦ý¦¹Àx¦s®æ±ø¥ó¥u¯à¥Î¦b¤@­Ó³W«h¤W)
¨Ã¥Î¿ô¥Ø´£¥Ü¤è¦¡
20170412¸ß°Ý.rar (313.85 KB)

ÁÂÁ¤j¤j
lo

¦^´_ 1# tr24572411

  ¤j·§²q¤@¤U
1.¥Hh61¨Ó»¡¡A®æ¦¡¤Æ±ø¥ó³] ¨Ì¤½¦¡ =len(h61)>0 ¥[®Ø
2.¬Ý¤£À´

TOP

¦^´_ 2# KCC


·PÁ¤j¤jªº¦^µª
¦pªG¥u¬Oh61Äæ¦ì¬O¥¿±`¥i¥H¨Ï¥Îªº¤è¦¡
¦ý¬OA¨ìGÄæ¦ì¬O³sµ²¨ä¥L¸ê®Æªí®æªº,©Ò¥HÀx¦s®æ¤@©w·|¦³¤½¦¡ªº¦s¦b
¨Ò¦p=IF([¥Ø«e©Ð¶¡ª¬ªpªí.xls]Sheet1!$A2="","",[¥Ø«e©Ð¶¡ª¬ªpªí.xls]Sheet1!$A2)
(¥k¤W¤è½s¿è¸ê®Æ)
¥u­n¦b¥H³sµ²ªº¸ê®ÆÀx¦s¤W´NµLªk¦A¨Ï¥ÎÀx¦s®æªº±ø¥ó
¦]¬°¨Ï¥ÎÀx¦s®æªº±ø¥ó«á´N·|¦]¬°¦³¤½¦¡¦s¦b¦Óª½±µÅã¥Ü¥~®Ø¤F

¤j¬ù¬O³o¼Ë
ÁÂÁ¤j¤j
lo

TOP

¥»©«³Ì«á¥Ñ KCC ©ó 2017-4-12 20:25 ½s¿è

¦^´_ 3# tr24572411


  ¥H¥Ü¨Ò test2 g1=IF([test1.xlsx]Sheet1!$G1="","",[test1.xlsx]Sheet1!$G1)
test2 G1=T91, test2 G1Åã¥ÜT91, ¤]¥[®Ø
½Ð°Ñ¾\®æ¦¡¤Æ±ø¥ó¥Îlen(g1)>0¡A®M¥Î¨ìg1¡Ba1¡A¦¹®É¡Aa1¤]·|¦Û°Ê¥[®Ø
¦pªG³o¼ËÁÙ¤£¬O¡A¨º¥Nªí§ÚÁÙ¬O¨SÅ¥À´.........

2017-04-12_202216.jpg (68.18 KB)

2017-04-12_202216.jpg

TOP

¦^´_ 4# KCC


   

ÁÂÁ¤j¤jªº¦^µª
±zªº¤è¦¡¬O¥i¥Hªº
«á¨Ó§Ú¦A¦¸­«·s»s§@·s¤u§@ªí¤~¥i¥H®M¥Î±zªº¤è¦¡
ÁÂÁ±zªº¼ö¤ß¦^µª
ÁÂÁÂ*ÁÂÁÂ
lo

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD