random selection

  1. MarkSELA

    Multiple choice question generator using randomly selected Excel ranges

    I downloaded and installed xl2bb but my Windows 11 system is refusing to unblock it. I've tried unblocking it through system settings but no success. I've tried placing the add-in in a trusted folder and still not working. I am designing a worksheet which will generate a random selection of math...
  2. B

    random search with multiple conditions

    Hi I am looking to do a random search on a sheet for auditing purposes. One issue is that the range of the search is not constant as new entries are done to the sheet weekly. I have two conditions: 1) the record must not have already been audited, 2) the result cannot return a blank Level...
  3. P

    Excel Random Seleciton under couple of conditions

    I am making peer evalution group and rator should be selected randomly among same department collegues. I have a table of records (named "Table1") and I want VBA to randomly return 5 individual number (each number should be on the different cell and table header is called "rator1~rator5") from...
  4. iosiflupis

    Pulling a 5% sample from a table

    Hello all, I have a table that will have over 800 records when done. We need to be able to select a RANDOM 5% sample for auditing. The data that we will be using to determine selection will be in column A:A (Tracking Number). I have been looking at RANDOM, RANDBETWEEN, and INDEX. I also...
  5. C

    Random Number Selection with Criteria and Median

    Hello everyone, I was wondering if it would be possible to select a random number from an existing list based on criteria and having the return "random number" be within a range defined by the median (15% above and below the median). Customer No. Amount 123 $50 123 $300 234 $70 456...
  6. M

    Random selection of comboboxes

    Hi there, I have a userform with two option buttons and four comboboxes. If Optminor = True then combox 1, 2 and 4 is visible. If Optmajor=true then Combobox 3 & 4 are visible. Combobox 1 & 2 have constant list values but combobox 4 varies dependent on the value of combobox 1 & 2. Combobox 3...
  7. M

    Picking names for working a bar

    I need to randomly select from a list of names for people to work at a customer appreciation bar in our hotel during weekdays. There are 17 names that need to be selected for the 20, 21, or 22 workdays for the month. No weekend dates. Eight of the employees can be selected only once while the...
  8. N

    VBA: Random selection from list, no duplicates

    I am using the below code (provided by Tigeravitar) to randomly select statements to be audited and it is working perfectly with one exception: There is nothing in the code to keep from selecting the same statement twice. I need to randomly select X number of statements without any duplicates...
  9. J

    Excel automated random selection

    I have table that has repeated timestamps (multiple records within 1 second). there are a variable number of records within each second; ranging from 1 record to 103 records within a second. I wish to develop a method to select only one random record from all the records with the same timestamp...
  10. O

    Random selection according to the value in other column

    Dear Community, I am trying to create a macro to do what it is so called "random selection proportional to size". I have a table named "source" with names of cities in column B, population in each city in column C and the cumulative population for each row in column D. I have a cell (F5) where...
  11. E

    VBA to randomly select teams from list of players

    Excel 2013, Win 7 Pro Starting with column A (Player Names) and column B (Player rating - value between 0-10), I need a macro to divide the players into either 2, 4 or 6 teams randomly. Column A would have less than 100 names. Teams are named TeamA, TeamB...TeamF. TeamA competes against...
  12. Y

    Randomly selecting a certain repeating number in a matrix

    I am trying to randomly select a repeating number in a matrix. I have seen the different random number and random select codes out there, but specifically what I'm asking is how to go about selecting a number that repeats in a matrix multiple times, not numbers between a certain range or a...
  13. M

    Need help creating a sports schedule/bracket

    I'm fairly experienced with excel but there has got to be an easier way to do this... I'm trying to create a track schedule where there are 7 teams in a league. There are 5 track meet dates and 2 host sites per track meet date. There is 1 school that can't host meets (so only 6 host sites...

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