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

[µo°Ý] ¦p¦ó¥ÎEXCEL¼Æ¾Ú¼ÒÀÀ¥X¤U¦¸¥X²{¾÷²v

[µo°Ý] ¦p¦ó¥ÎEXCEL¼Æ¾Ú¼ÒÀÀ¥X¤U¦¸¥X²{¾÷²v

¥»©«³Ì«á¥Ñ gyeonwoo0128 ©ó 2017-3-3 19:57 ½s¿è

½Ð°Ý¤@¤U~
¨Ò¦p0-6
0µ¥©ó10%
1µ¥©ó20%
2µ¥©ó10%
3µ¥©ó30%
4µ¥©ó0%
5µ¥©ó20%
6µ¥©ó10%
¥i¥H¥ÎEXCEL¤ºªº¼Æ¾Ú¼ÒÀÀ¤U¦¸¥X0-6ªº¾÷²v¶Ü???

http://blog.xuite.net/hcm19522/twblog/489879717

TOP

¦^´_ 2# hcm19522


  ÁÂÁ§Aªº¸ê°T~·P®¦!

TOP

123.rar (6.86 KB) ¦^´_ 2# hcm19522

¤£¦n·N«ä~§Ú·Ó¤è¦¡¿é¤J«á~

ÀH¾÷¥X²{³£¥X²{¥þ³¡0©Î1³o¨â­Ó¼Æ¦r~

¥i¥HÀ°§Ú¬Ý¤@¤U¶Ü??

TOP

B2 =COUNTIF(C:C,ROW(A1))/COUNT(C:C)
¤U©Ô

C2 =RANDBETWEEN(1,COUNTA(A:A)-1)
¤U©Ô100­Ó
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089

½Ð°ÝML089¤j¤j

³o­Ó¤½¦¡¬O¬Æ»ò·N«ä??

TOP

¦^´_ 6# gyeonwoo0128

§A¤£¬O­n¨C¼Æ¥i¯à¥X²{ªº¾÷²v¶Ü?

»²§UÄæ²£¥Í1~´X¦ì¼Æ(ÃD¥Ø¬O6­Ó¼Æ)ªº¶Ã¼Æ
C2 =RANDBETWEEN(1,COUNTA(A:A)-1)
¤U©Ô10~100­Ó³£¥i¥H¡A¬Ý§A­nªí¹Fªº²Ó¸`¬O¤°»ò¡C

­pºâ¨C­Ó¼Æªº­Ó¼Æ/Á`¶Ã¼Æ´N¬O¾÷²v¦Ê¤À¤ñ
B2 =COUNTIF(C:C,ROW(A1))/COUNT(C:C)
¤U©Ô

{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

0µ¥©ó10%
1µ¥©ó20%
2µ¥©ó10%
3µ¥©ó30%
4µ¥©ó0%
5µ¥©ó20%
6µ¥©ó10%
¥i¥H¥ÎEXCEL¤ºªº¼Æ¾Ú¼ÒÀÀ¤U¦¸¥X0-6ªº¾÷²v¶Ü???


°²³]µ©¤l¤¤©ñ¦p¤W¤ñ¨Òªº²y, ²Ä¤@¦¸©â²y¥X²{¤ñ²v´N¬Oªì©l­È,
ÀH²Ä2.3.....¦¸©â²y«á, ¾÷²v«h¤S[ÀH¾÷]ÅܤÆ,
¥HÁ`¼Æ¦Ó¨¥, ¬Ý¦ü¦U¦³¥X²{¾÷²v,
¥H­ÓÅé¦Ó¨¥, ¨ä¥X²{¾÷²v¥u¦³0 ¤Î100

TOP

¦^´_ 7# ML089

§Ú¬O·QÀH¾÷ªº¨S¿ù~

¥i¥H¥Î¬J¦³ªº¼Æ¾Ú,¨Ó¼W¥[¼ÒÀÀªº·Ç½T©Ê¶Ü?

TOP

¦^´_ 9# gyeonwoo0128

¥i¥H¥Î¬J¦³ªº¼Æ¾Ú,¨Ó¼W¥[¼ÒÀÀªº·Ç½T©Ê¶Ü?

³o¸ò¼ÒÀÀªº·Ç½T©ÊÀ³¸Ó¬O¨S¦³Ãö«Y
1~6®æ¡A¹ïÀ³8¡B4¡B6¡B7¡B9¡B1¸¹½X
­Y¦³1~6¸¹½X²y¥Nªí1~6®æ¡A¨C¦¸ÀH¾÷©â¥X¤@²y¸¹½X¥Nªí¬Y¤@®æ¡A¬Y¤@®æ¤S¥Nªí¬Y¤@¸¹½X¡A³o¸òª½±µ¥H¸¹½X°µ¬°²y¸¹©â¥Xªº·N¸q¬O¤@¼Ëªº¡C

°²³] 1=A¡A2=B
1. ¥Î²y¸¹1¡B2©â5¦¸¡A1¸¹²y¦³3­Ó¤]¥NªíA©â¨ì3­Ó¡A2¸¹²y¦³2­Ó¤]¥NªíB©â¨ì2­Ó¡C
2. ³o¸ò²y¸¹A¡BB©â5¦¸¡AA©â¨ì3­Ó¡AB©â¨ì2­Ó¡A
3. 1¤Î2¹ï¾÷²v¤ñ³£¬O3:2¡A©Î¬O3/5:2/5
§Úı±o³£¬O¤@¼Ëªº¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD