Thank you for that question! I think the simplest way is to first generate the random numbers in a column, and then remove duplicates from the column. Here's my newest video about removing duplicates: ➡ ua-cam.com/video/8yYRpcOnCO4/v-deo.html Another way is to first create a column of all the numbers you want to be "randomized" (e.g. a range from 1 to 1000), with non-repeating numbers. Then in a column next to it, apply the *=RAND.NV()* function (e.g. for 1000 rows, the same number of rows as your first column). Then, select both columns and sort Ascending by the second column. This will re-order the first column and it will appear to be in random order. If you would like, you may watch a short video I previously made about sorting two columns together: ➡ ua-cam.com/video/AFBQ2SOYCJ8/v-deo.html I hope this helps, and have a great day!
I tried doing randbetween(0.1,1.899) and it doesnt seem to return values like 1.623 or anything with a decimal. Kept returning whole numbers. Am i doing it wrong?
You are not wrong. Randbetween() returns an integer, but not decimal values. I think you could try the formula Randbetween(100,1899)/1000 to get a similar effect.
@@officenifty Actually, i used the GUI random from the Format > Cell menu to specify the values i need since its got a min max input box. Thank you this, regardless!
@@gdmt Oh yeah, I totally forgot about the Random Number Generator dialog. Thanks for mentioning what worked! Your feedback can help me improve the channel.
Very nice tip, however, how do we restrict the random number to be a non-repeating random number?
Thank you for that question! I think the simplest way is to first generate the random numbers in a column, and then remove duplicates from the column.
Here's my newest video about removing duplicates: ➡ ua-cam.com/video/8yYRpcOnCO4/v-deo.html
Another way is to first create a column of all the numbers you want to be "randomized" (e.g. a range from 1 to 1000), with non-repeating numbers. Then in a column next to it, apply the *=RAND.NV()* function (e.g. for 1000 rows, the same number of rows as your first column). Then, select both columns and sort Ascending by the second column. This will re-order the first column and it will appear to be in random order.
If you would like, you may watch a short video I previously made about sorting two columns together: ➡ ua-cam.com/video/AFBQ2SOYCJ8/v-deo.html
I hope this helps, and have a great day!
I tried doing randbetween(0.1,1.899) and it doesnt seem to return values like 1.623 or anything with a decimal. Kept returning whole numbers. Am i doing it wrong?
You are not wrong. Randbetween() returns an integer, but not decimal values. I think you could try the formula Randbetween(100,1899)/1000 to get a similar effect.
@@officenifty Actually, i used the GUI random from the Format > Cell menu to specify the values i need since its got a min max input box. Thank you this, regardless!
@@gdmt Oh yeah, I totally forgot about the Random Number Generator dialog. Thanks for mentioning what worked! Your feedback can help me improve the channel.
@@officenifty Anytime man! Keep up the fantastic work!
RANDBETWEEN IS GIVING ERR PLEASE HELP
What were the values you used for RandBetween()? Can you please try RandBetween(1,100) and see if that gives you a number?