randomly

Would it be possible to randomly distribute a sum (say 100,000) over 10 distinct cells? "0" is an acceptable result for any given cell, and in fact 9 out of 10 cells could feature 0 with the final cell containing the full 100,000. I am just trying to randomly distribute the sum (on a...

I'm throwing together a simple spreadsheet which will contain a list of names populating column B. The purpose of the spreadsheet is to randomly select a number of names from Column B and list them in Column D. In C2, I have =COUNTA(B:B) which gives me the total number of names listed in Column...

Hi all, I am chasing some help please.. I have an excel sheet produced from my accounting system that has every product in rows (over 6k rows) and in column "I" it has a quantity i need a way of removing all the rows with "0" in the "i" Column. I this possible? There other thing is it has a...

Hello , I am looking at three separate macros right now. Say : macro1 macro2 macro3 . Below is the button to call Private Sub CommandButton1_Click 'Inside here I want to choose one of those macros at random End Sub How will I run just one of those three at random?

I have 2 set of numbers that I would like to mix them. My first set contains 15 numbers that I would like to combine with a set of 10 numbers and distribute them into colunms. From the set of 15 numbers, the code will choose 9 numbers (randomly) and combine with 5 numbers from the set of 10...

I have this table of the range B2:J6 And I am looking for a way to randomly distribute the letters A-I across. These are the rules: 1. A row can take just A or A and A . If 2 As, then they should be immediately adjacent each other. Example B2C2. 2. The first four letters can appear more...

Hi guys, first thanks to all of you who take part in this community, this is my first ever post but I've been lurking around and learning a lot from the content I see here. Now on with the question, I have created a workbook with Macros in it which used to run fine for the first 400 or so...

I need vba code for geting number of rows in randomly selected reigon only. please note selected region could be randomly selected. only i need the no of rows

Good Day, I have a data table like below starts from A2 to C19 Is it possible to ruffle those datas randomly by clicking a command button? Every column will remain with same datas ony their rows will be changed... Thank you... <colgroup><col span="3"></colgroup><tbody> NAME1 1 1 NAME2 1 2...

Hey, I am using the index match formula to check for two values that are in column A and B in the same row, and then it gives me the value that is in column I. I am using the following formula: INDEX($I$2:$I$200,MATCH(Y2&$W$3,$A$2:$A$200&$B$2:$B$200,0)) This works great when the text I am...

After I press a button, I want the macro to randomly select one of the cells (divided by names) based on a value in another cell. It's easier if I show it: Hopefully this gives enough to work with.

When I input a formula in a cell, it is randomly updating other cells in different columns with no apparent links. I have gone through and deleted all external links, I've reviewed all formulas to make sure they are manually removed, and I've gone through charts and shapes to make sure there...

Hello, I have a list of c300 student IDs and 13 tutors. Please could you tell me how to randomly assign an equal (as far as possible) number of student IDs to tutors? Many thanks, Adam

Hi, I am adding to my sheet a trading simulator. Out of 100 trades, the Win Rate, for example, is 60% (60 trades will Win out of 100). On the spreadsheet, I want the R-Multiple colum to reflect this by showing 60 (3.00) and 40 (-1.00). Each Win is represented by a ‘3’ and each loss by ‘-1.00'. I...

Hi, I have this code that randomly picks a different name from a list. Sub CommandButton1_Click() Dim lrcd As Long SendKeys "%^{F9}" Range("H31").Copy 'Range("C2:C7").PasteSpecial xlPasteValues lrcd = Sheets("Sheet1").Range("E" & Rows.Count).End(xlUp).Row Sheets("Sheet1").Cells(lrcd +...

I have a huge document with tons of these. And I always decide randomly which I will use on a given day. But I bet one of them takes up less space... thoughts? MC

I am trying to build a macro that does a couple different random selections. The first function would be to randomly select a name from a table on another tab; this portion is working perfectly fine. The second portion is a randomly generated Yes/No. Here's what I've got so far: Sub NewCast()...

I have a 3x3 migration matrix and I would like, based on the transition rates, to randomly choose which items to move from a state to another and keep the same distribution, for instance if i have this array: Pupil Grade Grade N+1 1 A A 2 A A 3 B A 4 B B 5 A B 6 A C...

Hi all, I am looking for vba whereby i can filter 10 percent of data for audit percent randomly. can anyone suggest the vba code for the same

Have been searching for a way to randomly assign x number of tasks to y number of people in an equitable manner--or as equitable as possible without success... I have 19 tasks and 4 people -- and more people may become available but to start only 4. The solution would need allow changing the...