random

  1. F

    Random and unique number between 12345678 to 87654321

    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
  2. B

    random selection from a specific worksheet to show in a specific cell in another worksheet

    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...
  3. C

    Random select time from game clock

    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?
  4. S

    Randomize Data in Power Query Based on Certain Criteria

    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...
  5. SkywardPalm

    Populate random quality assurance checks into a Criteria column based on a set percentage

    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...
  6. S

    Randomize PQ Results Based on Certain Criteria

    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...
  7. R

    Random value must be unique depending on date range

    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...
  8. J

    Random Multiple Choice Answer in a Random Order

    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...
  9. C

    Random generate multiple names from a list with exclusions & sorting

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

    VBA: Enhance and speed up random numbers and sorting, using spill functions

    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...
  11. D

    Random Number Within Specific Range (Function)

    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...
  12. K

    Randomization Based Off a Set of Rules

    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...
  13. K

    Randomization Based Off a Set of Rules

    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...
  14. L

    Random Variable in a predetermined range

    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...
  15. K

    A few questions about randomizing arrays while avoiding doubles...

    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...
  16. B

    Randon test generator based on some criteria

    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...
  17. M

    Randomly Select Based on a value of another Cell

    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...
  18. M

    Select a random name with a changing array

    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...
  19. C

    Equally Random Distribution

    Using the image below, is it possible to assign a Program Randomly to each employee, but where the Count and units are balanced to the best ability? Thank You!
  20. W

    Random clipart into cells via userform

    Good morning, all. I'm attempting to make a placard. The clipart is going to serve as a visual identifier (a 3 pallet shipment will have placard 1 of 3, 2 of 3 and 3 of 3 hopefully, that might be a separate post), all three placards need the same picture to tie them together visually. Cells...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top