random

  1. C

    Random generate multiple names from a list with exclusions & sorting

    Here's my table: Here's also the sheet...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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!
  12. 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...
  13. E

    Create Random Unique Groups of 5, Keep Duplicates in Column

    I have a spreadsheet of thousands of books that need to be broken down into groups of 5 titles. I want to know how many unique groups can be created from this list. The catch is, some titles have 600 copies, while some have only 1. How can Excel create my groups of books? Also, do I have any...
  14. I

    Entering data into a cell has duplicated it in random cells in the same column

    Hi, I'm working on a large spreadsheet for work (not built by me) and I've encountered an issue that I can't quite get my head around. One of the columns in the sheet is Occupation and another Address, some of which had previously been filled out and some of which were still blank. After...
  15. F

    VBA comparing Cells

    Need help with this. Looked through some similar posts but couldnt figure out how to adapt them. I got a value in cell B2 and a value in Cell B1 (a value between 0-10). They are values that are not allowed to be the same. If the value in B2 ends up to be the same as in cell B1 i need to call...
  16. T

    Is possible to shuffle answers in multiple choice test in EXCEL?

    I have a lot of questions and I need to quickly shuffle answers in Multiple Choice Test. (1 question has 4 answers, A,B,C, or D). For example: Is possible to do that by using VBA or with some formula? Thanks for the help.
  17. The_Rock

    Random Replace Characters in a Word

    Hi Folks I've been scouring the net but without success. I'm hoping the genius's here will be able to help me :-) I'm trying to mock up some work for my daughter to help her with Synonyms and Antonyms. What I would like to do, if possible is: Column D looks at Column F (which will be hidden)...
  18. W

    VBA Random selection from list of names

    Hi All, I'm working on a spreadsheet that I would like to pick a random name from a list of 10 names using a vba button. the list of names are in cells C3:C12 and I would like the selected name to appear in cell D3 Thanks in advance.
  19. B

    generate a random number to enter in a cell

    I am am looping through a range on my computer (Excel 2013) and where I find a number 1 I want to replace it with a random number between the bottom number in Cell I9 and the top number in cell I11 So what I need my code to do is Activecell.value= "Randbetween Range ("I9").value and Range...
  20. K

    Random Highlight only 1 in the each row

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I need a VBA, which can highlight 1 character out of 1X2 in the each row so far each time 14 total are selected within the 14</SPAN></SPAN> Example...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top