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

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

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

¦^´_ 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©Ô

2017-03-06.png
2017-3-6 20:53
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

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 : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD