1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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
  8. 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...
  9. 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...
  10. 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...
  11. 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.
  12. 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...
  13. 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...
  14. 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'...
  15. 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...
  16. SimonHughes

    Randbetween with no duplicates

    Hello, is there any way of using Randbetween function without getting duplicates? I am using Excel 2016, many thanks
  17. 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?
  18. K

    Randbetween and decimals

    Hey! I'm looking to generate some random numbers using decimals, like from 0.1570 to 0.1579 in that exact form. I've been trying for a while and beyond stuck!
  19. M

    Can't find error in formula

    Hey guys, I need your help. The situation: I have 10 standard six-sided dice and want to roll values of 4, 5 or 6. This for example represents a game with 10 Goblins attacking a Troll, needing a 4 or higher to damage it. However, the Goblins are quick to strike so they can reroll their failed...
  20. J

    RANDBETWEEN but Exclude integers from two separate cells

    If in A1 I have the integer 1, and in B1 I have the integer 3, and in C1 I want to generate a random number from 1 to 5 which excludes the integers 1 and 3 from these previous two cells, how could I accomplish this? I looked over the below thread, but it was slightly different, and couldn't...

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