# random number

1. ### Generate Random Value Based On Assigned Probability Per Group

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...
2. ### Random Number

Hi Everybody , I need a help . How to generate random numbers with some conditions...
3. ### Random Number Quiz

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...
4. ### Random number pick from array

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...
5. ### How to return a random cell value based on a condition

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...
6. ### how to generate decimal random numbers between -0.57 to 0.37 in excel

Hi, how can I generate decimal random numbers between -0.57 to 0.37 in excel? Thanks.
7. ### A Challenge - Randomly Work Through a List

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...
8. ### How to Create list of random numbers which gives specific total value?

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...
9. ### random unique numbers/ names put into a grid - help needed

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...
10. ### Creating multiple, repeatable lists of random numbers

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...
11. ### VBA Random Number with no Duplicates

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...
12. ### Random number from Selection

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?
13. ### Excel Wisdom

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...
14. ### 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...
15. ### Random Number Generator

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?
16. ### Sequential Invoice...with a twist.

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...
17. ### Random not very random

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

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

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