ªð¦^¦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 : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD