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

[µo°Ý] ±Æ§Ç¤½¦¡

[µo°Ý] ±Æ§Ç¤½¦¡

¥»©«³Ì«á¥Ñ john2006168 ©ó 2020-7-5 22:57 ½s¿è

½Ð°Ý¦³¨S¦³excel ¤½¦¡¥i¥H¦p¹Ïªº±Æ¦C?
Â^¨ú.PNG

test02.rar (6.73 KB)

=OFFSET(A$4,ROW(A2)/2,MOD(ROW(A2),2))
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

=OFFSET(A$4,ROW(A2)/2,MOD(ROW(A2),2))
¤U©Ô
ML089 µoªí©ó 2020-7-6 11:25



    MOD(ROW(A2),2,³o­Ó¤£¬O«Ü¤F¸Ñ.½Ð°Ý¬O¤°»ò·N«ä?

TOP

¦^´_ 3# john2006168

E2 =MOD(ROW(A2),2,)
¤U©Ô¡A¬Ý¬Ý®ÄªG´Nª¾¹D
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD