randomly

  1. H

    Randomly Distributing a Sum Over Cells

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

    Selecting a Specific Number of Random Names from a List Based on Values in a Cell

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

    Removing unwanted rows

    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...
  4. kelly mort

    Randomly run one out of three macros

    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?
  5. L

    Distribute known numbers into columns using VBA

    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...
  6. kelly mort

    Randomly Distribution of items across a range with vba

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

    Excel randomly stops responding after macro & data input

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

    Count no. of rows only from Selection area in xla

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

    Randomly mixing datas base on same columns..

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

    Checking both columnns

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

    Simple VBA to randomly select from a named row of cells

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

    Can't find a phantom link

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

    randomly assign equal number of students to tutors

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

    How to randomly change entries on this simulater

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

    VBA code to randomly pick from a list of names

    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 +...
  16. M

    Which is less "resource intensive" - "Clear Shape With Text" (ie rectangle) versus "TextBox"

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

    Randomization Macro

    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()...
  18. V

    Randomly assign a grade based on an exact uniform distribution and size (excel/VBA)

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

    Autofilter 10 percent of entire data vba

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

    Randomly & Equally Assign 19 Tasks to 4 People

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top