randbetween

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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?

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!

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

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