How to Create Random Numbers in Excel (including no repeats)

This is the best explanation I have seen on the rand function so far...Thanks a lot!

Hi mam
Your all lessons are amazing. I have a question that is 10000 is my total sale. I want to convert this value into 15 days but without repeating.

Pls suggest which formula will apply.

It much helpfull

How did you only get the spill error once?!
I got nothing but the spill error

i need to make random invoice depending in total of that invoice and i have a list of items at A and prices B

Unique + RANDARRAY suits my needs just fine - but why does it not always output x n number of results (ie 10 as you defined - though sometimes you get less than 10 numbers...) Also, what triggers the spill error?

I'm making my own Number Sense practice sheets, and the Google searches I've seen explain these functions so poorly; this video was a lifesaver

thank you so much

Hi, Please teach how to create a random number between 3,4. The number required like this in cell 3, 4, 3.5, 3, 3.5, 4, 4, 3.5

Thank you for your perfect explanation, in case I need to select the value randomly but just for many specific values I would specify them taking the percentage of repeated values that I will define, into account, what can I do? thank you

thank you SOOOO much! I needed this for my experimental design and it worked perfectly!

THANK YOU DEAR LEILA JAN, YOU ARE HELPFUL AND AWESOME LECTURER.

Hey!
Many thanks once more! Always with super accurate and straight forward examples!! Keep going the good work :)

How to create a lottery generator using specific numbers only

Wonderful info, Leila. I was scratching walls to create vba or macro in order to refresh the numbers, but your F9 method which I just tried on my random number generator works perfectly! It made my life a lot easier, and besides you teach a lot of some other important excel tricks. Thank you very much . . . .

I want to create order number not random? without dragging to the bottom of a very long column. But I want the numbers to react to an added or deleted row???

How to generate random numbers over a table (rows and columns)

how to generate a list of all possible 4-digit codes in excel, when repetition is not allowed?

Thank you! You are very talented and easy to understand!

Thank you mam..

A Great technique. Now I understand the entire content properly. Thanks once again Madam. May I also request you to please upload the video regarding creation of random letterrs and A TO Z alphabets.

Thanks Leila. Solved my problem as always

I require a 10 by 10 table in excel where the numbers from 1 to 100 are indicated. But they must not repeat. How will I do that?

Thanks

Good video :) Any nice tips for random names as well ?

Great video. This has helped me, along with a lookup formula, to create a random staff rota.

I learned a lot about rand function. I love you.

how to generate unique random numbers in an array of 9(rows) x 10(columns) i.e. each number in the defined array should be unique with no repeats

Thank you! :)

Is it possible to set a seed like in any ordinary program?

Leila, your video is amazing. Thanks so much. Can you explain how to make a sort number by group of columns (example: by area)

Hi Leila,
Is there any way to generate all possible combinations of multiple numbers for instance if I want all possible combinations of numbers 1,2 and 3 I know the total possible outcome is 6 by using the Combin function but I also want to know the possible combinations that are
1,2,3.
2,3,1
3,1.2
1,3,2
2,1,3
3,2,1

Mam I don't understand why hash spill error come but other concepts were crystal clear

How to generate only one time random number.
Please 🙏 help..

Hi Leila, you are amazing! Every day I learn something new from you. I need help extracting a random unique list from an existing list. My list has three columns. The first column contains names, the second column contains a case number, the third contains a resolution number. The names repeat (i.e. a name has various case and resolution numbers assigned to it). How can I extract a random list for unique names only? Thank you.

Thank you. I needed this for tutoring kids for time tables. This is truly amazing. So simple buy I didn't know how until I saw this. Lovely lady you are. :)

Can someone tell me what's this used for a friend of mine ask me for this. But Idk what's the purpose? Thank you

This is so convenient. Thank you so much for putting all these in one place, you rock!

Thank you

I have Office 365 and noticed that random number generator, which I created years ago, no longer recalculates when I depress F9. Through some experimenting on the keyboard, that the Function key + F9 now recalculates my 60 fields for random numbers. Just and FYI. Thanks for your videos.

suppose
In Row (list of medical name) i made a search box to find a name from (medical list only)which formula i had to use ....i don't want other name to show on that list....plz help me

Hi Leila, I am using a combination of CHAR and RANDBETWEEN functions to generate a random password of 10 character starting with Capital and a mixture of Alphanumeric and special characters but whenever the spreadsheet refreshes it changes the values and I like to keep the values.
=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(35,38))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(60,63))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(101,989)

Please How do i create an automatic unique id numbers

can u tell how to get 6 columns instead of rows

How would I do it to where it dont repeat a repeat number?

If i have
KMHK - 0001 - E
And i want to change KMHK-0002-E
And sequence go on how I can ?

Nice to see that I am not the only one who is still learning, I would love for you to do a "simple😂😂" googlemaps type route/distance calculator between two business locations. Love your channel.

Good Evening Ma'am, Thanks for all the information. Your videos continue to be great sources of knowledge for the multitudes. I have a quick question pertaining to the number ranges. Can you set the randbetween to only select whole numbers by tens or hundreds or thousands? [randbetween(100,900)] where it will only pick 100, 200, 300 ,400,ect randomly? I'm trying to make a homework generator for my daughter using similar problems that she sees in class, without having to randomly type out everything for each day. Thank you!