random

hi all, If we use Randbetween function (1,0) it should give us 50/50 in a long run. But it's accuracy has been questioned before: Since this is the top result in Google for "how good is Excel's RAND() function" it is worth updating the answers for later versions of Excel This paper by Guy...

Suppose I have success rate probabilities based on years of experience and I am looking to generate random simulations indication what year success is achieved. If not in year one, move to year two, and so forth until success. Year Success Rate 1 5% 2 15% 3...

Hi, Based on Mr. Excel's YouTube video showing how to create a random non-repeating letter grid I was wondering if anyone could help me create a random single letter or number grid for 26 letters of the alphabet by the number 0-9 Example: say A-Z are the columns and 0-9 are the rows and then I...

Is there a way I can generate a random alphanumeric string but with the 3rd, 10th and 17th characters having been specified? My current string looks like this; The 3rd, 10th and 17th characters will be stored as variables probably, though yet to do that part.

Hi All, - 1st post. I've lurked around here for a while - some really useful hints & tips ! I have a range of postcodes in a column. (The sheet is FARMDATA the Column is G:G) There are 1000's of cells each with a unique code. I've written an amateurish vba function to generate a single...

Hello, I am curious about this phenomenon. Recently, I have noticed that Excel 2016, when I add/subtract 2 numbers that only have 2 digits after their decimal points, the number that results has several other digits after the decimals; or, it will be XXX. 00000000058620000000000. I have...

Hello I hope someone can help me quickly :eeek: I am looking to create a spreadsheet to be used once a month for a prize draw we do for 3 random names. I get sent a list of around 100 people and each month I need to randomly pick 3 names from that list (1st prize, 2nd prize and 3rd prize)...

Randomised 7 patterns out of 9</SPAN></SPAN> Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> VBA, which can choose "7 random patterns" out of 9 from a My List of column A, and make a list of random in the 7 columns E:K as number of random rows are set in the cell B1</SPAN></SPAN> Example...

VBA random numbers generator with required sum </SPAN></SPAN> I need a VBA that can choose 7 random numbers out of 3 numbers, which are listed in the cells A4:A6 </SPAN></SPAN> Create for example 50 random in the cells F4:L53 without repetitions (I mean 2 rows should not be the same) as per...

Hi, i'm trying to apply =vlookup for the spreadsheet attached to look for portuguese translations into sheet1 ("original ptbr") and retrieve them into sheet2 ("match translation") but it is failing for some random values and i don't know why since the words and the translations are there. Here...

Hello,</SPAN> Here is a bit difficult random number generator task, because I need a VBA that can choose 7 random numbers out of 9, which are listed in the cells A4:A12 </SPAN></SPAN> Create for example 52 random in the cells F4:L55 but conditions is limit max repetitions 2 or 3 as shown in...

Hi there, I have a macro to auto zoom to a range when someone enters a sheet as this is where all the input fields are: sub enterSheet() ActiveSheet.Range("T1:CZ1").Select 'set range zoom ActiveWindow.Zoom = True end sub Is there an extra bit of code that I can slide in there to center this...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> VBA, which can choose "x random numbers" from a list of column A (list in the column a can be max 290 rows)</SPAN></SPAN> For example list shown in column A has 28 rows, I want "4 random (no duplicates), which I have placed in cell B1 and...

Hi All, I have created a Random Number Generator using the code below Private Sub CommandButton1_Click() Range("d2") = WorksheetFunction.RandBetween(-2, 2) Range("d3") = WorksheetFunction.RandBetween(-2, 2) which works exactly how I want it to What I would like to do from here is generate a...

Hi Guys, I dont know that I correctly described the idea but let me show what I mean: <tbody> Name Type Pcs Random name 1 A 1 Random name 2 A 6 Random name 3 B 3 Random name 4 B 4 Random name 5 C 6 Random name 6 C 8 </tbody> Now I want make a macro which will be separating rows...

Hello all. I think I have a dozy of an issue. i have been looking online with no anvil. In A1 i have this text. I would like cell A2 to show: Effectively a random word order. The space between the word will have a "/". Is this possible? I would like to keep the sentence in 1 cell...

Hi There, I know this has come up a billion times, but everything I have found has not solved my problem. I have a list of 50 hockey player names, a list of 10 intros, and a list of 10 ending sentences. For example: A1:A50 = player names, A60:A70 intro to a sentence ("I heard that" or "Someone...

Hello all, Hopefully the title says it all, but here is a bit more info. I'm creating a mailing list where each recipient is assigned to a cohort. I have an excel table dataset with 5000+ rows, and quite a few emails appear twice. To differentiate the emails, I made a quick n dirty COUNTIF...

Hey All, This is the the other (bigger) issue I am having within an Excel training game I am creating. Context: I am in the process of developing a learning game for a training class at work. It's based on the concept of the Around the World game we have likely all played with a Basketball...

I have a worksheet that has column A (state) and column B (individual ID #). I need to review 100% of AZ, FL, IA, TX. But only a random 15% for every other state (i.e. 15% of HI, 15% of NY, 15% of TN, not an overall 15% if the remaining states). Can someone help me to write a formula for this?