random selection

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

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

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

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

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

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

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

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

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

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

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

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