1. R

    RandBetween - prevent values changing - VBA?

    Hello, My question is in relation to RandBetween and freezing the output so that it does not change each time. I have multiple cells containing RandBetween, I would like to be able to freeze the output/values so that they do not recalculate each time the sheet / workbook opens or I do...
  2. G

    Random Number Generator Excluding Numbers Already in Cells

    Hi! I am trying to allocate a number of records that each need to be reviewed by 3 people, and randomly allocate them as the primary, secondary, and tertiary reviewer. So I need to randomly generate 1, 2 and 3 in a random order next to each record, but the numbers cannot double up (ie cannot be...
  3. A

    RANDBETWEEN per transaction id

    Hello I want to generate data based on sales/transaction ID. Each transaction can have more than one sales line (per department). In trying to generate the department ID, I need to have any random number between 1,25 that does not repeat for any of the lines where the transaction id is the...
  4. R

    Random value must be unique depending on date range

    Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created. I would like to have only unique random values per week, and a minimum of 2...
  5. R

    Multiple RandomBetween() Numbers - Change all to Fixed Numbers

    Hi All, Quick Question. I know that I can generate Random numbers with fixed numbers using Randbetween (001,999) If I have multiple Randbetween numbers on a sheet and want to 'keep' the numbers, how do I stop all of them refreshing / changing on opening and closing the sheet / pressing the...
  6. T

    RANDBETWEEN Two decimal numbers to produced a decimal number

    Howdy, I am stuck on a formula and am hoping someone here can help me. Essentially, i am doing a tolerance sheet. Showing the design value, the actual value and the difference between the two. There is a tolerance of +0.015 and -0.000. So if the difference falls out of this range i need it to...
  7. M

    Add up random time in a specific time range ?

    Hello everyone, I have a cell A1 where I generate a random Date+time which is between the time 8:00 - 18:00 : =RANDBETWEEN(DATE(2019,1,1),DATE(2022,12,31))+RANDBETWEEN(TIME(8,0,0)*10000;TIME(18,0,0)*10000)/10000 Let's say it results in : 29.05.2022 11:52:05 After that, in cell A3 I would...
  8. D

    RAND with decimals

    Hi, from reading another thread HERE, I think I've nearly figured out what I need =RANDBETWEEN($W$1,$X$1)+(ROUND((RAND()),2)) W1=4.6 (minimum to randomly select) X1=6.4 (maximum to randomly select) The final 2 is because I need the results format to come out as 4.54 or 5.67 for example. For...
  9. R

    Create random list then keep it unchanged

    Hi, I'm using randbetween() to create a random list of ten numbers. Repeats are ok, so it's just randbetween(0,300) in every cell. After I have created the list (and without using VBA) I want to keep that list as text. So I'd want it to generate the ten numbers but then somehow keep them as a...
  10. W

    specify gap size using Randbetween function

    How can RANDBETWEEN(1,850) be modified to select numbers <+8 or >-8 of the previous selection? Thanks, White Top
  11. H

    CAnnot get RANDBETWEEN function and Autofill to work in VBA

    Hi there! I am using VBA to do the following: I use it to write the RANDBETWEEN function in, say, cell A1. I then use the AUTOFILL command to copy the function down to, say, A10. I then highlight the range A1 through A10 and Copy/Paste the values generated by the Randbetween function copied...
  12. J

    Generate Random Numbers That Are Only Used Once

    I have to create a spreadsheet where employees click on a number 1-41. Each number is in its own cell and each number is hyperlinked to another tab where the user is presented with a question they have to answer. What I am trying to do is use RANDBETWEEN to generate a random number between...
  13. J

    Is it possible to Index a single cell array?

    I was trying to randomly select items from an array, I don't think the below is possible so I'm going to break it out into cells. I have an array in A1, everything below is submitted with ctrl shift enter just in case. A1={"test1","test2","test3"} I want to be able to...
  14. M

    Simple Macro to re-trigger RANDBETWEEN

    I want a button to trigger all of my RANDBETWEEN cells to re-randomize. What's the simplest macro should I use to do this? I was copying/pasting a cell, but this changes the selection. Thanks in advance.
  15. C

    Concatenate Moving Range

    Hi there! Been a long time lurker of the forum, but finally forced to ask for help on something I have a column with values e.g. in B1 I have "red", B2 has "Blue", B3 has "Green" etc. In another cell I have a randbetween function e.g. C1 = randbetween(1,N) I want to concatenate from cell...
  16. S

    Placing Conditions on Randbetween to Avoid Clashes With Other Columns

    Hi Guys, Firstly, apologies for the total lack of a snappy title... I have a job interview next week in which i will have to show how i would handle receiving responses to certain questions on a questionnaire. My idea is to Randbetween and Choose(Randbetween) to give myself a real working...
  17. C

    vba to calculate a randbetween in a range of cells relative to a selected cell

    Hi, I'm looking for some vba that will do the following if possible: Example: cell R1 contains the following: '1>5' and when the macro is run it puts a 'formula' into the range from R3: down to the last row containing data in Col A (eg.R3:R7540). The formula calculates a 'Randbetween 1 and 5'...
  18. T

    Ignore Blanks and Choose Between Candidates

    Hello all, I have been trying to come up with a solution that will allow me to NOT use RAND() for a basic scheduling tool. 1) We have 10 people 2) There are 5 shifts (Monday-Friday) 3) There is an OMIT field, marked as 0 or 1, where if omit=1, they are not scheduled for Monday or Tuesday. This...
  19. SimonHughes

    Randbetween with no duplicates

    Hello, is there any way of using Randbetween function without getting duplicates? I am using Excel 2016, many thanks
  20. A

    Modifying Randbetween function

    I am using randbetween(-10,10) to generate numbers, Occasionally I get a 0, is there a way to modify this so that I never get 0?

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