random

I have a worksheet that has column A (state) and column B (individual ID #). I need to review 100% of AZ, FL, IA, TX. But only a random 15% for every other state (i.e. 15% of HI, 15% of NY, 15% of TN, not an overall 15% if the remaining states). Can someone help me to write a formula for this?

Scenario - I have 10 employees, who complete 10 sales per day. My data refreshes each day, so it's just prior day information. I would like to randomly pull 1 transaction per employee to perform an audit. I am comfortable creating a random sample, but not applying a one per user idea.

I am looking for some help to create the correct VBA code to use with my ActiveX Button to generate a random number between 1-24 ( These numbers will be in cells H4:H28) that would then highlight the corrosponding cell (using a light red background with bold black numbers) in the matching random...

Hello, I'm trying to find a formula (Or VBA, but i have close to zero experience on that) that retrieves me a series of random samples based on a weighted criteria. Let's say i have the following Table <tbody> Jon 1 Mike 2 Jon 3 Jon 4 Jon 5 Mike 6 Mike 7 Zero 8 Zero 9 Jon...

I am trying to generate random time entries Between two time limits in Excel. the problem i am facing is the generation works fine with the same day time calculation as soon as the time passes midnight, Excel gets confused and give me wrong values values. I need to generate random entries then...

Hello again I wasted all day trying to resolve this problem without help but unfortunately unsuccessful. :confused: so here I am asking for help the great helpful community here. I have a column A with 10K numbers in ascending order and could be even more . I need to pick 500 random unique...

hi guys, Two cells question with random numbers formula: In A1 I have random number generator in a range from 1 to 99. = RANDBETWEEN(1,99) In B1 I want to add formula which would fluctuate values from A1 but within a certain range. So I have in B1 this formula: =A1+RANDBETWEEN(-25,25)...

Hi, I'm havin a problem finding the latest date in a column. In column B, I have an imported dataset which puts the date in DD-MMM-YY hh-mm-ss-aaaa... In column A, I have selected the first 9 digits using the LEFT function, and returned the DATEVALUE: =DATEVALUE(LEFT(B3, 9)). I have also...

I am working on a model of charging load of electric vehicle. I am attaching a link to an excel workbook for your better understanding. Column B contains random time values Column G to P represents houses and each house can have 1 car. So the each time values needs to be distributed in one...

Hi All, Quick question. I want to generate a list of random numbers each 125 digits long, including zeros, with a full output - not reduced to an E+ number. Excel seems to have limit on the RAND and RANDBETWEEN after about 17 digits. Any suggestions appreciated. Thanks,

I am trying to create a random password selector with the following parameters. I want to put a lot of passwords (around 5-10 columns with 100 passwords in each column) onto a worksheet and hide it I want the formula to say "when there is a value in B2, put one of the random passwords from the...

I need help creating a schedule that generates random selections with limited repetitions. The selections will go down the column with limited repetitions down the row. I thought I was on the right track but I'm stuck...

Hi all, I have a random monetary value that is divided by a random number between 2 and 12. For example £6,992.00 divided by 6 = 6 equal amounts (after using the ROUND formula) of £1,165.33. I need the sum of the rounded instalments to always equal the original value (in this case £6,992.00)...

I have found code online to generate a random number using VBA (on click of button) How do I get it to display a certain cell (H5) rather than in a msgbx? Sub random_num() 'Initialize the random number generator '=> Randomize : add this before you call the Rnd function to obtain...

I have already VBA for random numbers, but I would like to add loop for how many times the random is run and the number foe sample is in Z25 "Sub TwentyfiveRandOf25() Dim anArray(1 To 25) As Long Dim i As Long Dim randIndex As Long, temp As Long For i = 1 To 25...

Hi I got run time error 1004 running the code below. Tried everything but no luck. Any help would be appreciated. It is just to fill a cells with random number Thanks Sub random1() Dim i As Integer Dim j As Integer For i = 0 To 10 For j = 0 To 3 Workbooks(1).Worksheets(1).Cells(i, j).Value =...

Hi, I want to generate a list of non-repeating random numbers between 0001 and 9999, but I only need a total of 2051 of the 9999 I want to have 5 separate / individual columns, each with one set of non-repeating numbers. Any suggestions, comments, ideas welcome. Thanks

I'm using Excel 2016. At Random times, I cannot scroll thru the sheet, nor can I type anything in a cell. Is there a fix or workaround? Thanks

Hi, Hope this makes sense to someone. A1 = Question 1 A2 = Possible answer A A3 = Possible answer B A4 = Possible answer C A5 = Possible answer D In cells A6, A7, A8 & A9 I would like to display the contents of either A2, A3, A4 or A5 this must be in a random order as I wish to drag the...

Hi Peoples; - I require to generate a col string of random 0's or 1's - (no blank cells) effectively just a simple random binary data string. The appliance of weighting is not required... I would have thought this would be available as a simple Excel function but cannot locare it...? Thank...