randbetween

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

Hi all, I need to add this formula to a set of times I've calculated but can't figure out how to do it. Could anyone please help, that would be much appreciated. Thanks. Phil

Cells AE2 thru AH2 have the following characters: AE2: COO1536578 AF2: AFI58491599 AG2: GHU4582154 AH2: UHT7851596 In AB2, I'd like to write a formula similar to the below, which will choose one of these cells at random and populate it in AB2. I currently have a working formula as follows...

I've got about 100 rows of data, with 100 columns across. I want to use the below formula to give me one random output from the columns in each row. The formula gives me a #REF if I plug in columns instead of rows: =INDEX($C:$C,RANDBETWEEN(1,COUNTA($C:$C)),1)

HELLO FORUMS, I need to make 217 RANDOM integers in 217 CELLS that are UNIQUE (no duplicates) NOW when I use this formula (=randbetween(2,218)) in my first cell and drag down I get many duplicates (found using conditional formatting) HOW do I make these random integers WITHOUT getting...

Hi All, I don't have a Monte Carlo Simulation Add-in (if any of you know of a good free one please let me know), so what I did was use the randbetween() function and then used and =if to create probabilistic choices (ex. I am building a model to forecast financial projections, but not entirely...

Hey guys, Let me first say "thank you" in advanced. I was asked to create a random number generator. I am using the =CHOOSE(RANDBETWEEN(x,x) function. So for example, My formula looks like this...

Using Windows 7 and Excel 2013. I'm trying to create a function to facilitate table top role-playing (i.e. Dungeons & Dragons). I want the formula to accomplish a randbetween for a specified number of times. I would also like the formula to be non-volatile (i.e. doesn't recalculate every time...

I have a 2 column 'Table' with some data (alphabets not numbers). I want to generate random data from that table (column 1) into a cell. I want to use 'Table' because when I add new data to the 'Table'... the random data will automatically consider the new data from the table. Please help!

I have a database that has monthly results for several different entities that are fractions (.55.56%). I want to generate some additional monthly results that are say between 80% and 120% of the existing numbers. I have 3 months of data and I want to expand it so I have 12 months to make the DB...

randbetween no repeat with fix sum example fix sum => B10 = 10.240 A1 to A10 RANDBETWEEN

i want to create 180-200 sec ACD how I done with this ? this is the example of 240-270 acd =RANDBETWEEN(1,RANDBETWEEN(2,RANDBETWEEN(3,RANDBETWEEN(1000,RANDBETWEEN(2000,3599))))) but I don't know how this is done ? and I want above formula for 180-200 acd... any help please?

It’s my first time posting to MrExcel although I’ve been using your forum to teach myself the program for the past year! I can’t say enough how awesome and helpful this community is! I have a list of 63 names that I need to sort into 9 groups of 7. This step is easy enough – however – I would...

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

So, let's say I need to have 24 numbers randomized. But in a particular way! They all should be chaotically randomized according to these rules: half of them (12 cells) should be randomized between 10-60 the rest (also 12 cells) between 80-90 so there's a gap between of 61-79 values, they are...

Greetings, Currently, I have a spreadsheet of text data that I need random blocks of. I have managed to take the data from the source column and arrange it "randomly" over five columns, but it isn't quite random. For example, the first row only contains values from the first row of the source...

Hello everyone, Is there a way to use the RANDBETWEEN function and add bias towards the upper or lower bounds? I have used formulas such as ROUND(100*(RAND()*RAND()),0) to give me a left biased distribution and ROUND(100*(1-RAND()*RAND()),0) to give me a left biased distribution. However, I...

Hello, I'm a Dungeon Master for my Pathfinder RPG group and am making an Initiative/Combat Tracker in Excel 2013. I'm not sure how to go about doing this. What I'd like to do is make a button that when pressed will refresh data stored in cells with the =RandBetween(1,20) function in order to...