Generating Random Numbers in Excel

  Рет қаралды 113,367

Technology for Teachers and Students

Technology for Teachers and Students

Күн бұрын

Пікірлер: 32
@elinat6993
@elinat6993 2 ай бұрын
I had not heard of this, thanks!
@VenomQuill
@VenomQuill 4 ай бұрын
Great tutorial! Thank you very much for the information!
@jeaninehaack1459
@jeaninehaack1459 4 жыл бұрын
Great video... thanks for sharing your vast knowledge and making things easy to understand.
@CherryGummy-kk6li
@CherryGummy-kk6li 4 ай бұрын
Amazing Video! It helped me a lot 😁
@dragus2904
@dragus2904 4 жыл бұрын
Epic as always, thanks for the video mate!
@roymark5845
@roymark5845 4 жыл бұрын
The title of the video caught my attention so I watched it to learn why anyone would ever want to generate random numbers. I'm still wondering!
@horvathgabor5485
@horvathgabor5485 4 жыл бұрын
But there are reasons: a teacher generates random questions for the kids. A student generates random data from a database to create a table with valid but impersonated data to excercies e.g Excel functions... Not to mention the games... :) (Gambling, dice, etc.)
@josephcosgroveF4fl
@josephcosgroveF4fl 4 жыл бұрын
I was wondering the same thing. Perhaps it may work for my next lottery ticket on the 1st and 16th of each month.
@BackFire10mm
@BackFire10mm 4 жыл бұрын
I use random numbers to sample healthcare providers. I have to prove the selections were in fact random.
@saadounsalimi447
@saadounsalimi447 Жыл бұрын
Awesome video
@pgkannan
@pgkannan 4 жыл бұрын
Excellent one. Thank you so much. Can you please share dashboard.
@viletcordova1370
@viletcordova1370 4 жыл бұрын
very helpful thank you cer
@MrY1313
@MrY1313 4 жыл бұрын
Thank you!
@oukkalyacine3051
@oukkalyacine3051 3 жыл бұрын
Thank you so much
@funmiamarvi
@funmiamarvi 4 жыл бұрын
Thank you so much!
@noellie9937
@noellie9937 2 жыл бұрын
THANK YOU!!!!!!!!!!!!!
@durfelx3890
@durfelx3890 Жыл бұрын
is it possible to use the numbers in 2 separate cells as the lower and upper range?
@m.pejmannia8344
@m.pejmannia8344 4 жыл бұрын
Thank you
@sandrapatriciabuckley3676
@sandrapatriciabuckley3676 4 жыл бұрын
Interesting, but I am thinking how can you apply it? some examples the real life. Thanks
@Norlen94
@Norlen94 4 жыл бұрын
Great video. I have a question. I have a list of 8 people names. I need to sort them randomly each time. How do I do that?
@YesterdayIAteMyDog
@YesterdayIAteMyDog 2 жыл бұрын
Helpful
@bradleycarmont2257
@bradleycarmont2257 11 ай бұрын
How do I generate random numbers with Decimal Points?
@broadbandtogod
@broadbandtogod 4 жыл бұрын
Does anyone know how to program this: I fill a cell with a number, 1000 for example. When I increase the value above 1000, the surplus is filled in another cell instead. How does one do this?
@camel99able
@camel99able 4 жыл бұрын
you can use if formula. you can select a cell that you want to see surplus then write a formula on that cell. for example if(A1>1000, A1-1000,0). Here put 1000 in A1 (or whatever choose a cell).
@Kolian1274
@Kolian1274 3 жыл бұрын
Hello dear Ihave 10 deferent numbers as Inout I want to see how many random number I can create from that 10 number For example my number is 03,05,07,11,13,15,17,19,21,23 Find out how many random number I can creat using above numbers Thanks
@BackFire10mm
@BackFire10mm 4 жыл бұрын
Question. How do you stop the duplicates.
@jopinofcabra
@jopinofcabra 4 жыл бұрын
Old guy here. Does "between" 5 and 9 now include 5 and 9? Many years ago that would have been "between 5 and 9, inclusive" or in the range of 5 to 9.
@rustyvoiceinwilderness9580
@rustyvoiceinwilderness9580 4 жыл бұрын
WOW Cool. How about ensuring there is no duplicates
@ML-qt8hr
@ML-qt8hr 3 жыл бұрын
Can try the "remove duplicates" in the Data tab
@stickom
@stickom 3 ай бұрын
Hi broke man here, I am doing Fantasy 5- rand hope for some money, lets see... hmmm...
@aitankwok3030
@aitankwok3030 4 жыл бұрын
????????????????? what is Excel
@Kolian1274
@Kolian1274 3 жыл бұрын
Hello dear Ihave 10 deferent numbers as Inout I want to see how many random number I can create from that 10 number For example my number is 03,05,07,11,13,15,17,19,21,23 Find out how many random number I can creat using above number Thanks
Automatically Open Several Excel Files
4:27
Technology for Teachers and Students
Рет қаралды 30 М.
How to Create Random Numbers in Excel (including no repeats)
7:12
Leila Gharani
Рет қаралды 228 М.
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 45 МЛН
When you have a very capricious child 😂😘👍
00:16
Like Asiya
Рет қаралды 18 МЛН
My scorpion was taken away from me 😢
00:55
TyphoonFast 5
Рет қаралды 2,7 МЛН
How To Create A Random Sample In Excel (2 Methods!)
5:46
Steven Bradburn
Рет қаралды 105 М.
Excel Conditional Formatting in Depth
17:39
Technology for Teachers and Students
Рет қаралды 332 М.
Excel - Generate Random Numbers, No Repeats (No Duplicates), Unique List
18:11
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 22 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 288 М.
Benefits of Naming Cells in Excel
11:19
Technology for Teachers and Students
Рет қаралды 54 М.
The Excel Trick I Use EVERY DAY (and you should too!)
11:21
MyOnlineTrainingHub
Рет қаралды 273 М.
Excel UserForm Course 1 - Your First UserForm
13:58
TeachExcel
Рет қаралды 128 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 1 МЛН