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

[µo°Ý] ½Ð°Ý¦p¦óÅã¥Ü

[µo°Ý] ½Ð°Ý¦p¦óÅã¥Ü

½Ð°Ý¦p¦ó°µ¨ì  Åã¥Ü¤u§@ªíªºB1¿é¤J1-12ªº¼Æ¦r,¦¨ÁZ­pºâ¤u§@ªí´N·|Åã¥Ü¹ïÀ³ªº³õ¦a.¨Ò¦p5´NÅã¥Ü(1)¨ì(5)³õ¦a,11´NÅã¥Ü(1)¨ì(11)³õ¦a.

12³õ¦aÅã¥Ü.rar (33.9 KB)

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2021-11-12 11:46 ½s¿è

D2 ¥k©Ô P2 ¤U©Ô=IF((ROW(A1)>$B$1*10)+(¦¨ÁZ­pºâ!A1=""),"",¦¨ÁZ­pºâ!A1)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

«D±`·PÁ ¤£ª¾©ÒÅã¥Üªº¯à§_¦p¦¨ÁZ­pºâ¤u§@ªíªº®æ¦¡¤@¼Ë?¥i§_¥Î¥¨¶°¤è¦¡¦b¦¨ÁZ­pºâ¤u§@ªí§e²{¥X¨Ó.Ä´¦pB1¬O10«h¦b¦¨ÁZ­pºâ¤u§@ªí¤W§â11¸ò12³õ¦aÁôÂð_¨Ó¥u§e²{¨ì10³õ¦a,

TOP

«D±`·PÁ ¤£ª¾©ÒÅã¥Üªº¯à§_¦p¦¨ÁZ­pºâ¤u§@ªíªº®æ¦¡¤@¼Ë?¥i§_¥Î¥¨¶°¤è¦¡¦b¦¨ÁZ­pºâ¤u§@ªí§e²{¥X¨Ó.Ä´¦pB1¬O1 ...
yujen16 µoªí©ó 2021-11-12 12:36


¦pªþ¥ó¡A½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

12³õ¦aÅã¥Ü.zip (51.63 KB)

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2021-11-12 14:23 ½s¿è

¦¨ÁZ­pºâ (®æ¦¡¤ÆµLªk¸óªí) =Åã¥Ü!$B$1*10
¦¨ÁZ­pºâ A1:L116 ®æ¦¡¤Æ (¥Õ¦r¦â)=ROW()>$S$1
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

©êºp§Úµü¤£¹F·N §Ú­«·sµo¶K ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD