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

°lÂܱqÄÝ°Ñ·Óªºbug?(¤½¦¡¦³¸ósheet³sµ²Àx¦s®æ»Poffset)

°lÂܱqÄÝ°Ñ·Óªºbug?(¤½¦¡¦³¸ósheet³sµ²Àx¦s®æ»Poffset)

sheet1[A1]=Sheet2!A1+OFFSET(B1,0,1)
sheet1[A2]=B2+OFFSET(B1,0,1)

¦bSheet2[A1]«ö°lÂܱqÄÝ°Ñ·Ó·|Åã¥Ü
sshot-115.jpg
Sheet1[B2]«ö°lÂܱqÄÝ°Ñ·Ó«h¥i¥¿±`«ü¦VA2

¸Õ¹L2003»P2007ª©³£¦³¬Û¦P±¡§Î...´ú¸ÕÀɮצpªþ¥ó

test.rar (1.32 KB)

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