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

[µo°Ý] ¸ê®Æªí°ÝÃD

¥u¦³¤F¸Ñ¤½¦¡ªº¹B§@¤è¦¡«á,¤½¦¡¤~·|¬°§A©Ò¥Î,¤£¦C¥X©Ò¦³¸Ñµª,¥Øªº¤]¦b³o¸Ì.®¥³ß§A.¦h¤F¸Ñ¤F¤@­Ó¤½¦¡.

TOP

¦Ñ®v¤£¦n·N«ä¡A¥i¥H¤F¡A¬O§Ú¨S¬Ý²M·¡¤Ö§ï¤Fsheet1!C¡A¾Ç¥Íª¾¿ù¤F¡AÁÂÁÂ

TOP

ÁÂÁÂANGELA ¦Ñ®v«ü¾É¡A¦ý¥u¦³©m¦WÄæ¥i¥H¡AµLªk¾ã¦C¤@°_ÅÜ°Ê¡A§Ú¸ÕµÛ§ï=IF(INDIRECT("Sheet1!A"&ROW(C2))="","",INDIRECT("Sheet1!A"&ROW(C2))) ¦bsheet2ªºb2Äæ¤]¤£¦æ¡A³Â·Ð¦Ñ®v¤F

TOP

sheet2!a2=IF(INDIRECT("Sheet1!A"&ROW(A2))="","",INDIRECT("Sheet1!A"&ROW(A2)))

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD