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

[µo°Ý] Ãö©óIF§PÂ_ªº°ÝÃD? (register313 ¤j¤j¡AÁÂÁÂ) (¤w¸Ñ¨M)

[µo°Ý] Ãö©óIF§PÂ_ªº°ÝÃD? (register313 ¤j¤j¡AÁÂÁÂ) (¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ av8d ©ó 2012-4-23 08:29 ½s¿è

[attach]10537[/attach]

ªþ¥ó¤¤¬O¤@­Ó±Æ¯Zªº½ü­Èªí~¤@¦@¦³6­Ó¤H½ü­È~
¦ý¬O½ü­Èªº¤H¤@ª½³£¤£©T©w~³Ìªñ­nÂX¼W¨ì14¤H~

¼gªk´N·|§ó¥[½ÆÂø~¤£ª¾¹D¬O§_¦³¨ä¥L°µªk©O~
§Æ±æ¥i¥H¦bH2¥´¤WÁ`¤H¼Æ~
µM«á¤À§O¦bA3~F3¥´¤W¼Æ¦r~Åý¤U¤èªº¼Æ¦r¦Û°Ê¶]¥XÁ`¤H¼Æ­È!!

¤£ª¾¹D¬O§_¥i¥H?

¥H¤U§Ú¦bªþ¤W¤@¦@7¤H½ü­Èªºªþ¥ó~
ask4.rar (7.57 KB)
¤è«K¤j¤j~®e©ö°µ­Ó¤ñ¸û~!

¥»©«³Ì«á¥Ñ register313 ©ó 2012-4-20 17:23 ½s¿è

¦^´_ 1# av8d

A1=¤H¼Æ(©Î=COUNTA(3:3))
A4=IF(COLUMN()>$A$1,"",OFFSET($A3,0,MOD(COLUMN(),$A$1))) ¦V¥k½Æ»s,¦V¤U½Æ»s

TOP

¥»©«³Ì«á¥Ñ av8d ©ó 2012-4-23 13:28 ½s¿è

¦h¥´¤F@@ ½Ð§R°£ ÁÂ@@

TOP

¥»©«³Ì«á¥Ñ av8d ©ó 2012-4-23 14:23 ½s¿è
¦^´_  av8d

A1=¤H¼Æ(©Î=COUNTA(3:3))
A4=IF(COLUMN()>$A$1,"",OFFSET($A3,0,MOD(COLUMN(),$A$1))) ¦V¥k ...
register313 µoªí©ó 2012-4-20 17:09


ask5.rar (8.11 KB)
ªþ¥ó¬°¶i¶¥ÃD

Ãö©ó¤é´Áªº¬P´Á?¦pªG¹J¨ì¬P´Á¤Ñ¬O§_¥i¥HÅý¤ÑÅܦ¨¤é?
­ì¨ç¼Æ¤½¦¡¦p¤U:
B2==IF(ISERROR(WEEKDAY(A2,2)),"",WEEKDAY(A2,2))
¦ý¬O¬P´Á¤Ñ·|Åܦ¨¤C

¦A¦¸·PÁÂ!!

TOP

¦^´_ 2# register313

¬Ý¤F¦n¤[¤~µo²{¤@©w­n¥ÎMOD³o¨ç¼Æ
=IF(COLUMN()>$A$1,"",OFFSET($A3,0,COLUMN()))
³o¼Ë´N¨S¦³¶g¦Ó´_©l¤F~
¤@¶}©l¬Ý¯uÃøÀ´.....
¦Û¥H¬°·|¥ÎExcel¤~µo²{
§Ú¥u¬O®³Excel¨Ó·íWord¥Î........Orz

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD