rand

Howdy, I am stuck on a formula and am hoping someone here can help me. Essentially, i am doing a tolerance sheet. Showing the design value, the actual value and the difference between the two. There is a tolerance of +0.015 and -0.000. So if the difference falls out of this range i need it to...

Hi I want to generate random time. So what I tried is that A1 = 24:00:00-rand() But I got error message but when entered the 24:00:00 in A1 and then in B1 I did this B1 = A1 - rand() Excel accept that! Why is that? Thank you.

I need to prevent my sheet from constantly recalculating the RAND() function on the sheet any time I do something. I tried to change the Calculation Options to manual, but that was for Excel and not my specific sheet. My Sheet, Cases (2), has multiple RAND() functions but once I generate the...

Is there a for me (non literate Excel user) to extract a number of questions from a pool of test questions in Excel? The questions have in the first column numbered 1-200 I would like to pick random questions, say 52, for each person from that pool of questions. Then the next person would...

hi all, If we use Randbetween function (1,0) it should give us 50/50 in a long run. But it's accuracy has been questioned before: Since this is the top result in Google for "how good is Excel's RAND() function" it is worth updating the answers for later versions of Excel This paper by Guy...

Hi Community - I'm hoping you can help: I have two Columns: On a data sheet titled 'DataSheet' i have the following: Column A: Contains a list of product categories Column B: Contains a list of sub-categories for each category On my active Sheet titled 'BusinessSheet' I want to be able to...

Hello, I'm not sure if this is entirely possible but I'm trying to find a way to simply have cell count up by 1 everytime another cell changes value. Eg// Cell 1A has the formula =rand()*10 Cell 2A would add by 1 every time excel refreshes and changes the value. Alternatively, if code doesn't...

I have two worksheets open on my screen (or multiple monitors) at the same time, but the sheets are from different workbooks. When I make a cell change in one workbook sheet, any rand() values are changed in the other workbook sheet. I'm using a Windows computer, but my friend with a Mac...

I have a Excel sheet which does a lot of calculations based on RAND function of Excel. The table represents a probability function where RAND is used to define a probable value between two given numbers. So everytime, I press calculate button in Excel I get a different value in the cell. Now I...

I'm working on a stock management system with excel VBA. So far I've been able to add content to excel cells using a user form I created but I'm has trouble generating a random number for my stock id. Here is the sub routine I used. And I get true in the product I'd cell . Sub random_random...

Hello, I am trying to do this: 1. I have 2 cells with a list of names (2 names each). 2. I need an if-statement that when the names are chosen in any combination, the if statement will calculate a random number from another list (let's say numbers are 1-5) and each number will have a weighted...

If in A1 I have the integer 1, and in B1 I have the integer 3, and in C1 I want to generate a random number from 1 to 5 which excludes the integers 1 and 3 from these previous two cells, how could I accomplish this? I looked over the below thread, but it was slightly different, and couldn't...

okay so I am still not really picking up on the syntax of VBA coming from having heavy SQL experience. I am pretty sure I am having an issue with the declarations but can't figure it out. - I totally stole this code from another post and was adjusting it based on my parameters. I am...

I created two columns with random numbers, however in the next column I want to use an if statement. For instance if the number in the specific column and row is between 1 and 2 I want it to output a "1". Likewise if a number is between 3 and 4 I want it to output a "2" and so on until I get to...

I have a worksheet which lists down column A, a number of employee names. In Column B, it lists the total number of inter-department referrals each employee has referred to someone else to generate sales. I'd like to do a drawing which would randomly select a name, taking into account the...

HELLO FORUMS, I need to make 217 RANDOM integers in 217 CELLS that are UNIQUE (no duplicates) NOW when I use this formula (=randbetween(2,218)) in my first cell and drag down I get many duplicates (found using conditional formatting) HOW do I make these random integers WITHOUT getting...

Hey guys, Let me first say "thank you" in advanced. I was asked to create a random number generator. I am using the =CHOOSE(RANDBETWEEN(x,x) function. So for example, My formula looks like this...

Howdy, Yeah the title's a doozy but let me explain: I'm trying to develop an auto-sked excel file for my place of work where a weekly schedule is gen'd up that accounts for what training events, lesson topics, briefs, etc. get performed every day. The training is conducted by instructors who...

Hi, I've got a problem which I initially thought would be very straightforward and that most likely I would be able to easily find a ready made template. My conundrum is that I have a list of 150 names, and 12 times a year around a 100 of them get together on different tables, around 15 on...

My end goal is to create a model that predicts revenue from closing fees based on the amount of deals done every month, after applying a failure rate. For example, in month 4, I have 4 deals that will be started. Based upon a close rate of 70%, I need to predict how many will be closed. I...