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

[µo°Ý] ¸õÄæ¨ú­È

[µo°Ý] ¸õÄæ¨ú­È

¸õÄæ¨ú­È.rar (1.99 KB)
Sheet1
·Q±N²Ä5¦C¨C¹j3Ä檺­È¡AÅã¥Ü¦b²Ä9¦C¡C
½Ð°Ý:C9ªº¨ç¼Æ¤½¦¡­n«ç»ò¼g?
ÁÂÁÂ!

Sheet2
·Q±N²Ä5¦C¨C¹j3Ä檺­È¡AÅã¥Ü¦b²Ä9¦C¨Ã¦V¥ª¶ñº¡¡C
½Ð°Ý:C9ªº¨ç¼Æ¤½¦¡­n«ç»ò¼g?
ÁÂÁÂ!

¸õÄæ¨ú­È.rar (1.99 KB)

¸õÄæ¨ú­È.rar (1.99 KB)

¦^´_ 3# hcm19522
·PÁÂhcm19522¤j¤jªº¨ó§U¡C

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2020-12-6 15:02 ½s¿è

Sheet2!=IF((MOD(COLUMN(A1),4)<>1)+(C5=""),"",C5)
Sheet1!=OFFSET($C5,,COLUMN(A1)*4-4)&""

https://blog.xuite.net/hcm19522/twblog/589496622
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

©êºp!²Ä¤@¦¸¾Þ§@¡A½d¨ÒÀ£ÁYÀɤ£ª¾¹D¬°¤°»ò·|Åܦ¨3­Ó?
½Ð¤U¸ü¤W­±²Ä1­ÓÀ£ÁYÀÉ´N°÷¤F¡CÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD