Arrange Numbers 1 To 11 Row Wise Randomly With No Repetition
Mar 29, 2014
Arranging row wise an array of numbers from 1to 11 randomly with no repetition. I need it for 700 rows.
Sub test()
Dim a1(1 To 11, 1 To 2) As Double, a2(1 To 11, 1 To 2) As Double, a3(1 To 11, 1 To 2) As Double
Dim a4(1 To 11, 1 To 2) As Double, a5(1 To 11, 1 To 2) As Double, a6(1 To 11, 1 To 2) As Double
Dim a7(1 To 11, 1 To 2) As Double, a8(1 To 11, 1 To 2) As Double, a9(1 To 11, 1 To 2) As Double
Dim a10(1 To 11, 1 To 2) As Double, a11(1 To 11, 1 To 2) As Double, i As Integer
Randomize
I need to be able to create a list of all combinations (where position doesn't matter, therefore its not a permutation) of a list of numbers with repetition enabled. I need to provide anywhere up to at least 10-15 numbers if possible and they are integers normally between 1 and 72. Example: (for numbers 1, 2, 3)
I have a 1x20 array with the numbers 1 thru 20 inside. I want a piece of vba code to randomly sort them. I will do this in a loop to create different "starting arrays" for an optimization code. I just need to be able to randomize the beginning. How is this done? I cant have duplicates.
with this problem (which I've been trying for weeks to solve).
I have a column ("C") of 640 numbers, which I need to randomly sort and place into the adjoining (ten thousand) columns. I then need to correlate each of these 10k columns with column "B".
The problem I have with the attached (which works for small numbers), is that when I increase the table size to 640 rows and anything more than a dozen or so columns, it takes forever to calculate and Excel often crashes.
I am trying to calculate Change for following set. The Calculate field below shows how to arrive at the change. Any logic that I can use to get to Change? Match AccountID and find change in Value from Wk =1 to Wk= 2 without using pivot table option
With this msg i am attaching one excel. I have the data on the basis of "image wise files data", but where how to get "record wise image numbers", i am unknown on this.
how to create a list (I know how to calulate the count) of combinations without repetition when choosing 2,3,4 and 5 words from a set of 5 in Excel 2007.
I organize monthly audits of work completed by the team. Essentially we all audit each others work; but we cannot audit our own work.
I would like a formula that will evenly distribute the jobs for audit without passing a job back to someone that owns the job originally. e.g. Gareth cannot audit a job Gareth owns, but can audit Zach or Claire's jobs. The Excel sheet attached should make it easy to understand.
So far I have tried: =INDEX(A2:A24,RANDBETWEEN(2,24)) but this duplicates data and I cannot get it to evenly spread the jobs amongst the team.
I have column A with 1000 cells tall with a bunch of random whole numbers from 1-100. In cell B1 I enter the formula:
=MATCH(25,A1:A1000,0)
This goes through the data and outputs the location of the first instance of "25". However my data has 8 instances of "25", and I want to know all of them. So basically in B2, B3, B4, ... I want to enter:
If i have a string of information in 2 workbook and I need to check if the details in column a in workbook 1 has a duplicate entry in column b in workbook 2 and if there is a duplication, then highlight it in both workbook. How can I go about it to create the codes so that I will be able to use it for different workbooks without changing the codes every now & then?
Scenario: - Monthly invoice verifications for a few vendors. To verify info from the manual invoice againts the auto invoice (2 different workbook for each vendor) Need to verify info from Column A in Manual invoice against column B in Auto invoice. If there is a same data in both column, then data to be highlighted.
I need a sum of top 5 numbers category wise. I have attached a sheet in which I would be requiring Sum of Top 5 for the month of May. I have shaded cell where i would be requiring a formula...
Also I may want to include other category as well.. For e.g. sum of top 5 for the year 2011 as well... I have tried every thing i could from Sumif to sumproduct to Large...
i have a data of empl their birthdate wise. i want it to sorting from birth day wise for example first " DAY then Month then year". day come first then month then year. find attched file.
I am attaching a sample file wherein my requirement is that on clicking one button labelled (actually textBox) "show Data sheets" should display a list of all three data sheets which are hidden and other button labelled (actually textBox) "show Reports" should display a list of all three Report sheets which are also hidden.
Actually users will be able to put data in Datasheets whereas Report sheets contain formula etc and users will not be able to put any data on those report sheets.
Only one sheet should be displayed on the screen ie when user will move to Datasheet1 from Introduction sheet, only Datasheet1 should be displayed.When user will move from Datasheet 1 to Datasheet2 only Datasheet2 should be displayed and so on.
For Example: Below 2 columns there are four dates available, i want to know the count for date 1/1/2010, how many UK?, IND?, US?. As per the below format....
Date UK IND US 1/1/2010--- 1/2/2010--- 1/3/2010--- 1/4/2010---
Date Region 1/1/2010UK 1/1/2010IND 1/1/2010UK 1/1/2010UK 1/1/2010IND 1/1/2010UK 1/1/2010UK 1/2/2010IND 1/2/2010UK 1/2/2010US 1/2/2010US
This is my below data. No.Request NoDateSilverGold 1456661-Dec-20121 22018561-Dec-20121 32089561-Dec-20122 42099721-Dec-20128 52012121-Dec-20122 62068782-Dec-20122 72075952-Dec-20123 82045682-Dec-20123 92032252-Dec-20122 102015852-Dec-20121
in other sheet i have products Data by date wise 1-Dec-122-Dec-123-Dec-12 TotalRequest countTotalRequest countTotalRequest count ABSilver2 Gold12
My query is how to get the total Request Count for Silver and Gold by date wise. Eg: Answer should be Silver has 2 (counts) & Gold has 3 (counts) How to arrive to that.. i have tried.. countif, countifs....
