randbetween

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

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

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

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?