I need to use a function that is not onyl random, but only uses a person's name on a list once. On a list of ten people, RANDBETWEEN picked the same person three times in ten key strikes. How can I use RANDBETWEEN but also make sure ever person's name gets picked ONLY once? This is for a drawing for secret santa.
View 9 Replies
When I use the =RAND() function, everytime I do anything within my spreadsheet the number changes. Is there a way to get that number to change after(for example) 10 refreshes of my spreadsheet instead of every single time I do something to it?
View 6 Replies View RelatedI have a workbook that calculates a RAND function based on input in another cell. Specifically, the formula in E2 selects a random text string from another range depending on data entered in D2. I want to be able to fill this formula down for use multiple times.
The formula works fine on its own, but the problem comes when I, say, move on to D3 to input more data. E3 does its random calculation as it should, but E2 also recalculates; I want E2 to remain static once it calculates the first time.
I'm attaching the workbook in question. The calculation I'm referring to is in the 3rd worksheet.
TLL Injury Machine.xlsx
I have been using the RAND and Vlookup functions for the following without success.
I have 4 numeric Pools or Groups;
1. A1:A18 (1-18)
2. B1:B18 (19-36)
3. C1:C17 (37-53)
4. D1:D17 (54-70)
I also have E1:E20 (20 existing Numbers from 1-70)
I want Excel to select at random a total of 20 numbers
and place them in F1:F20.
I will specify a quantity from each of the 4 groups.
Eg.
In cell A20 I enter 4 to obtain 4 numbers from grp 1,
In cell B20 I enter 6 to obtain 6 numbers from grp 2,
In cell C20 I enter 8 to obtain 8 numbers from grp 3,
In cell D20 I enter 2 to obtain 4 numbers from grp 4,
However there must not be any duplicates between
E1:E20 and F1:F20!
How do I use RAND to generate random numbers between 0.25 & 0.5?
View 9 Replies View RelatedIs there a way to control the number generation. I would like to be able to run different scenarios with the same set of random numbers, then regenerate the random numbers and do it again. Right now every time I do anything in the spreadsheet, I get a new set of numbers.
View 4 Replies View RelatedI have 379 sample identities in my Excel spreadsheet in A2:A380. I want to randomly assign a number from 1-5 to each of these.
View 1 Replies View RelatedHow can I use the RAND function to generate a list of simulated phone numbers.
View 9 Replies View RelatedI'm making a custom BINGO board in Excel 2010 for a family reunion, so it doesn't contain numbers; instead it has words (like "has brown eyes" or "served in the military"). the first sheet is the board and looks like a traditional BINGO board with the same number rows and columns with a center FREE space. On the second sheet is the list of all the phrases I'm going to use, one phrase per cell, all in Column A.
In BINGO cells, I want it to use one item (phrase) in each box but NOT repeat within the board. I have the following code in each cell and it works EXCEPT, there is no code telling it to make each cell unique, so sometimes it may repeat.
=UPPER(INDEX(ColumnA,((RAND()*(Data!A1-1))+1),0))
I want to call on the existing rand() function as a part of the function i've written, however I'm getting an error saying sub/function not defined when I go to compile. How do I have to define rand() so that vba knows that I want the use the existing function?
View 6 Replies View Related
