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

¤ñ¹ï

¤ñ¹ï

sheet1.a1 b1 c1¡K¬O¤é´Á
°²³]­n©Msheet2a1 b1 c1¤ñ¹ï¡A°²¦p¤é´Á¤@¼Ë¡A
±Nsheet1¤@¼Ëªº¤é´Áªº¾ã¦Ccopy¦Üsheet2¬Û¹ïÀ³¤é´Áªº¾ã¦C

¥»©«³Ì«á¥Ñ sunnyso ©ó 2013-5-4 10:12 ½s¿è

¦^´_ 1# dreming
@sheet2

A2=IF(Sheet1!A2="","",HLOOKUP(A$1,Sheet1!$1:$65536,ROW(),0))

¤½¦¡¦V¤U,¦V¥k½Æ»s
ss

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD