random number

Hi everyone. I would need help in creating a formula to populate a random value of 1 or 0 based on a percentage value assigned per group. Suppose my data looks something like this. I need to populate the third column with either 1 or 0 on whether that person is part of the sample or not...

Hi Everybody , I need a help . How to generate random numbers with some conditions...

Hi, I am looking to see if anyone can help with regards to an excel math formula to help me solve and generate an unusual math puzzle I came across recently. I loved the puzzle and am interested in trying to develop a formula for it in Excel but to no avail. The puzzle presented 25 random...

Hi Excel Guru's After checking numerous threads i can fine solution to my problem. I have an array of numbers and need to pick a certain (variable) amount from that array, see below 1 2 3 4 5 6 7 8 9 10 11 13 14 15 16 17 18 20 21 22...

I am looking for a help with a formula in excel. I have two tabs in my excel Updates: One: My input is in cell F1 When the input is 1, it should check if ID 1 is available in "updates" sheet and return a random "Code" from "updates Sheet" which has ID 1. IF ID 1 is not available in Updates...

Hi, how can I generate decimal random numbers between -0.57 to 0.37 in excel? Thanks.

Hello, I have two questions: 1. RANDBETWEEN() This function automatically recalculates each time the spreadsheet recalculates. I realise I can turn off automatic calculation, however this will cause other problems. How can I produce a random number and essentially "keep it" for use else where...

How to get specific total as sum of randomly(using randbetween/rand()) generated values? I always want to get specific value as the sum of randomly generated values For example I have sheet as shown below. <tbody> A B 1 =RANDBETWEEN(5,10)→ 5 2 =RANDBETWEEN(5,10)→ 6 3...

I am doing a cow patty drop for my local non-profit community group. We are selling tickets (numbered 101-676) for the event. In order to show who's name ends up where in the tennis court that will be marked in a 24 x 24 grid, I would like to show each ticket number (or preferably the...

I am trying to create challenge/response cards. Each card will have a 5-digit number in the upper-left and lower-right corner along with a series of rows containing a line number and 3 pairs of challenge/response words. Rather than have have copies of these cards, I want the central office to...

I have a question regarding some VBA code I am using to generate random numbers. In a varying range, I want the code to generate a random number, and then check all previous ranges to ensure there are no duplicates. When I run the code step by step, I can see that it sometimes work. I.e. The...

Hi, I want to select random value from selection. I have just: Dim my_range() Range("A2").CurrentRegion.Select my_range = Selection How to use Random function to select random value from my selection?

Assuming I have two tables, Table 1 and Table 2: <tbody> 1 9 11 20 40 6 10 23 44 49 10 18 23 24 40 5 10 25 29 44 10 16 18 31 42 1 4 9 43 50 </tbody> Table 1, are numbers between 1 and 25 randomly selected and Table 2, are numbers between 20 and 50 randomly selected...

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

Dear all, I am trying to create a Random number generator that only includes the numbers: 0, 1, 3 and 5 Can anyone please help?

Hi. Hope your day is great. Wondering if you could help me with the following: I think it may be easy for you (but very appreciated by me!): I have maybe 25 invoices in one folder, depending on what item the customer orders, and the invoice # is always in the same cell. What I need is a macro...

Hi, For a bit of fun, I have a list of quotes which when my main macro is run, automatically selects and displays one. Simplified code I'm using is: Sub Randomi () Dim i as integer i = (i * Rnd() + 1) MsgBox i End Sub But everytime I first run this macro after first opening the...