random generated

Hi All Sorry, I have to ask for a bit of help here. I have a daily report downloaded which gives a worksheet name of 'report123456' but the numbers are randomly generated. In order for my subsequent macro to work, I think I need to either: a) change the worksheet name to 'Data' b) have a way...

Hello How are you my friends! I hope you will help me to complete this table It is a Time sheet I want you to create numbers of work time according to the following condition: in (E8) set valuein [F8:AJ8] random numbers SUM random numbers in [F8:AJ8]= SET VALUE in (E8)I want to cancel...

I'm trying to do a quick excel sim of the monty hall problem. I've used RANDBETWEEN(1,3) in columns B and and F for the initial guess and the actual winning door however I need to determine which door is opened. Basically my question is how do I make excel do my title, pick a random number...

Hey! I'm looking to generate some random numbers using decimals, like from 0.1570 to 0.1579 in that exact form. I've been trying for a while and beyond stuck!

Dear Excel Experts, I found formulas that allow users to select names randomly:- =INDEX($A$2:$A$11,RANDBETWEEN(1,COUNTA($A$2:$A$11)),1) But how do we omit the one that has appeared/selected to avoid repetitive value? The reason why I need this is to ensure staff select unique tasks, no one...

I want to generate random grades for 30 hypothetical students in 3 courses, Math, Chem, and English. I can supply a mean and standard deviation and use NORM.INV and RAND() to compute a random grade in each subject for each student. What I can’t figure out is how to make the grades for each...

Hi, for a bingo game, I'm looking for a way to randomly fill a matrix of 18 rows by 9 columns with only 90 numbers (1 - 90). This means there are 72 open positions (or filled with zero's). There are some rules to be applied to fill the matrix: Each row can only have 5 numbers The first...

I am sure you can tell by the title this is going to be fun! I have an array of random number of card players getting a random (but equal) number of cards. The cards are all numbered based on "power". So card 50 is weaker than card 49. I have the random number generator all set up to...

Hi all, I need help with generating random numbers that equal a specific total. for example: I want random numbers from A1 to A15 that equal to 6 I would need the same for columns B through J And as an added bonus stump question :) I need each of those rows to equal a specific number all the...

Hi, I want to select random value from selection. I have just: Dim my_range() Range("A2").CurrentRegion.Select my_range = Selection How to use Random function to select random value from my selection?

Hello all and thank you for allowing me onto the Mr.Excel message boards, I just have one quick question for you guys and I'm sure it's trivial... Let me explain my situation. :biggrin: My information systems 102 prof, (St. Francis Xavier University, Eastern Canada) post-midterm, realized...

I'm generating a random integer in column A (product) between 1 and 20 and another random integer in column B (quantity) between 1 and 100. I want to record the total quantity for each product in column C. How do I do this?