random

Hello - I have a spreadsheet with about 1500 employees. I need to pick a random employee from the list daily, but ONLY if they have a qualifying "x" in a column on the spreadsheet. Example: If there is an X in column C, I want to select a random name from column B. If column C is blank -...

I have variable lists that will have 200–1000 values in them. ex: 1 Reliable 2 Practical 3 Responsible 4 Organized 5 Detail-oriented 6 Logical 7 Hardworking 8 Dedicated 9 Honest 10 Loyal etc... The user will be able to put a number in a cell and a different cell will...

hello i want to create list of random and unique numbers of 8 digits between 12345678 and 87654321 but any digit should not be repeat for example 12345678 ok 21345678 ok 32145678 ok 12245678 not ok. due to repeate of 2 87654321 ok 87754321 not ok due to repeat of 7 pls help

Hi As the title states, I am seeking to have a command button on sheet "Home Page". When selected, a random selection would happen on sheet "Audit-Staffing" in column F. The result would populate in cell B2 on sheet "Monitoring". another twist is that in column AO of sheet "Audit-Staffing" in...

For quality analysis I want to select a random 20 minutes from a 80-minute rugby game. How do I customise the '=TEXT(RAND(), "MM:SS")' so that its giving me a starting number between 0.00 and 80.00?

Hi PQ Gurus, I have a tall order, which I know I would NEVER be able to figure out myself, and am hoping one of you experts could assist. I know the requirements are pretty extensive, but would appreciate ANY help in trying to figure this out. I have a large data set (small sample below), and...

I am attempting to populate random quality assurance checks into a Criteria column, if there are less cells populated with a Criteria (High Cost, High QTY) than the required (say 10%) quality check, then a "RANDOM" will be the cell's value. I can't wrap my mind around how to accomplish a...

Hi Power Query Gurus out there! I don't have extensive knowledge of Power Query, but use it for simpler tasks. I'm currently using it to query data from a SharePoint list (not relevant to my question), and I'm looking to have PQ look at the data (sample data below), and randomly select 3 IDs...

Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created. I would like to have only unique random values per week, and a minimum of 2...

Hello, I am a math teacher and many of the online tools that I use allow me to import questions and 4 multiple choice answers from excel. So my goal is to have excel create the right answer and then 3 random unique values (so multiple correct answers don't appear) and put those 4 values (1...

Here's my table: Here's also the sheet...

Sorting Arrays VBA does not have a built in sort function, which means you need your own sorting code. But now, the Excel Sort function can be used in VBA, and based on my testing, it is faster than my quicksort function. Note that the array must be 2D, eg (1000,1) or (500,3) For example if you...

Hello there, Seen a lot of literature on this but not something as specific (via organic search). Let's say I have a list of numbers in one column. What function (no macro) would enable me to randomise the appearance of a number not in the first column but within a specific range (from 1 to...

Hi everyone, I have a rather tricky problem to solve. For each row in my table (for each person) - refer to screenshot named "My Table", I would like excel to randomly generate a 9 digit number (in Column N) but based on a certain set of rules. Here is how I currently generate them 1 by 1...

Hi everyone, I have a rather tricky problem to solve. For each row in my table (for each person) - refer to screenshot named "My Table", I would like excel to randomly generate a 9 digit number (in Column N) but based on a certain set of rules. Here is how I currently generate them 1 by 1...

Hello, I have an issue, I need to: Ask the user for the highest and lowest possible values of the random numbers Ask the user how many rows and how many columns she/he wants to create Insert a new sheet into the workbook with the name "‘RandomNumbers"’ and fill this sheet with the appropriate...

Hi Everyone I seem to be having problems and I just can't figure it out. Been googling a few days now without any clear answer. I have this sheet: ABCD1Primary ColorPrimary HEXSecondary ColorSecondary...

Hello guys, I have an Excel Spreadsheet with a specific sheet called "DB" which contains 7 different fields: Column A: Question Column B: Alternative 1 Column C: Alternative 2 Column D: Alternative 3 Column E: Alternative 4 Column F: Difficult Level Column G: Subject And basically, we have...

Hello- Trying to create a formula that randomly selects a tracking ID for each associate. In addition, make an alternate selection, but it can't be a duplicate of first random selection. Was thinking a VLOOKUP & RANDBETWEEN combo, but stumped. Not sure if I have to go through VBA route? Any...

Hi all, I have to do 150 random draws to choose between 4 names, let's say A B C and D. But depending on the draw, sometimes there is only A and D participating, or A, C and D, etc. So the array is changing. I know this formula could do it if the array was always the same...