hello guy...im new about excel..i want to learn on how to generate random 50 number with 10 group..thank you
hello guy...im new about excel..i want to learn on how to generate random 50 number with 10 group..thank you
What does this mean?
Please provide a fuller explanation. Do you want 10 groups of 50 numbers? Or do you just want 50 numbers? Is there a range between which these numbers should appear?generate random 50 number with 10 group
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
sorry i'm weak in english language..i hope u can understand..a list of number from 1 until 50..then i want to make 10 group randomly with 5 numbers for each group..and each number dont repeat..
for example :
from number 1 until 50, i can generate randomly
group 1 : 20,11,23,9,13
group 2 : 1,5,35,4,32
group 3 : .....
group 4 : .....
until
group 10
thank you very much..
Here is a spreadsheet on creating 50 random numbers.
thanks...it's really help me...thanks again...![]()
alansidman..how if i want to change the output to word? for example the rank is 1, then change to "a".
example:
5 = x
34 = q
42 = z
thanks![]()
Create a table of what each number is equivalent to on a separate sheet. Then apply the vlookup function.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks