i had a basic spreadsheet for my incomings and i got wiped with my hd exploding!! i know how much the total was i just need a way of creating a list of random amounts within a specified range over a year to give to my accountant.
I have a frequency list (frequency per year) resulted from previous calculation. What I want is to generate random number as many as the frequency in the specified year, so that every year I will get the same amount of random numbers as the frequency. It is kind of the opposite of FREQUENCY function (but with random numbers involved). I need to use the result for further calculation.
I need the easiest way to randomize or generate team numbers in a league. Using COL A assign numbers between 1 & 8 without duplicates. Then repeat 5 more times. This has to be done on the spot and has time constraints as the players will be waiting for their team assignments.
EXAMPLE: I have 48 players which will be assigned to 8 teams of 6. I want to randomize the drawing so the same players don't play on the same teams each week. Also to be able to adjust number of teams determined by how many players are present. either 6 , 8, or 10 teams.
How do I create a 6 digit unique random number for use as an ID in column A. Once created the rows with preexisting 6 digit unique random ID numbers must not change every time new rows are added.
View 9 Replies View RelatedI need to create a function that adds a predetermined amount (lets say 120) to a cell (lets say A1) every time another cell (lets say B1) reaches a 10 (like 10,20,30,40 etc)
Lets say the B1 is 30, i need A1 to recognize that it needs to show 360 as its value (adding 120 for every 10 of B1)
I am working on a Random Cycle Count Generator that provides random SKU#s based on 3 separate columns of SKU listings. The user clicks a button to generate the SKU#s to cycle count for that day. What I would like to see is a date stamp in the columns next(B,D,F) to the referenced SKU listing(A,C,E) based on which SKU#s are generated. This will let me see the last date that the SKU was generated. I would also like it to automatically save after generating.
View 2 Replies View Related=COUNTIF(F3:F38,"=VL") This works for totaling the VL in the cells in the column but what if I need it to add DVL in the same column to that total? So I need it to add both VL AND DVL as one total. I can make it add one or the other but not both
VL DVL
VL VL
VL
VL
VL
5 2
[URL]
I have Column C and D filled with numeric temperature and humidity data. I need next 16 rows (8 more set) to be filled with randomly generated dummy data by the values exist in C and D. Same numbers but randomly distributed.
I am creating an excel spread sheet for a project I am doing, I need to create a daily chart for 6 months of water usage that results in averaging set targets.
I have made a chart with the average uses per day but would like to have daily numbers that average out to what i have but in a random sequence e.g. i have that a shower uses 320 litres per day for 2 people is there a way i can make a chart that says: 300 (a1) 340(a2) 260(a3) 360(a4) etc i need to do this for 180 days with random numbers generated to average the same overall. I dont know even how to generate random numbers.
I am trying to generate random numbers between 0 - 9 in ten cells that do not repeat an always include every value 0 - 9 (0, 1, 2, 3, 4,...9). The object is to have the numbers randomize each time. So cells A1:A10 could look like this:
3
9
4
5
1
0
6
8
7
2
Or, they could look like this:
9
7
5
2
8
4.................
I was just wondering if there is a way to make rand or randbetween functions work with text. Alternatively, is there another function that will allow me to do this, without adding numbers in the parallel row.
I want the column, to randomly choose between "male" and "female". I do not want to add additional rows or columns preferably..
Is it possible to use the =randbetween() function to generate a random number between 0.8 and 1.2.
View 4 Replies View Relatedgenerate 100 random numbers between 100 and 300 in some range of cells like A1:j10
View 1 Replies View Relatedis if there is a way to generate random numbers between 0001 and 9999. I always need to always have 4 digits. The first couple of numbers can be 0 so that I can maximize the number of variations.
I want excel to generate a random integer between 132 and 321 and place it into cell B10. What formula would I need to enter into cel B10 to do this
View 9 Replies View Relatedi have worked in access using vba procedures. i can easily create a form in access that generates a random integer number between 0 and 20 and the user will guess the number between 1 to 20 if the random number is 16 and the user enters 14 the program will display a msg box saying too low or too high. here is the code .
Option Explicit
Private Const MAX = 20
Private Const MIN = 1
Private iKey As Integer
Private lTries As Long
Private Function Random() As Integer
Random = CInt(Int((MAX - MIN + 1) * Rnd() + MIN))
End Function
Private Sub cmdGuess_Click()
Dim lGuess As Long
now i have to do the same thing in excel create a program that will ask the user to enter numbers between 0 to 20 and see if the random number and user guess is same or not. but i have never worked in excel using vba procedures how can i achieve the same thing in excel using a vba procedures.
I'm using Excel to generate a userid based upon criteria (e.g. IF column A = 2, and not in array(another sheet), use a random id). This works, but I want an incremental id (whether already used up).
I am using =MAX(IF(LEFT(Users!B1:B19900)="2",Users!B1:B19900)) to get the highest number in the array ...
How can I create a Makro that looks for values (e.g. values > 90) and that then generates a list with: all the values greater than 90, the row names and column names of the values?
I am pretty sure I will need a Makro for this, but how to create it. I am using excel 2010.
I have attached a file to give you an example. The red table is the table with the values. The blue table is what I want to be generated automatically. In the example I did it manually.
Workbook1.xlsx
I have in column A and B. A includes two (or may be more) kind of items, i.e. drink and snack. Column B has for example water next to drink and chips next to snack. The list is huge.
How can I generate a drop down list with data which uses the A column to identify the items which it should include. I want to make two separate drop down lists for drink and snack and each should include only those options which belong to those categories. I.e. drink list should be like water, cola, pepsi, etc. The problem is that the list is huge and it's not possible to sort it. Some kind of if statement structure with named range? The drop down should be dynamic in a sense that if I add line to data, it should be picked to the right drop down menu.
Any way/method to make a certain number of cells randomly generate to a specific value you want? I only want to use the number from 1 to 60.
example:
1 37
2 29
3 34
4 2
5 58
6 38
7 =198
I want to generate numbers (1 to 15) in cells A1 through O1, but the
number in each cells should be unique compare to the other cells, how
can I do it? If I use =randbetween(1,15), I can not get unique number
in each cell, some numbers are duplicated.
How do I use RAND to generate random numbers between 0.25 & 0.5?
View 9 Replies View RelatedI'm trying to generate a dataset to use as an example in a class I'm helping out with.
I want 75 cases (that is, 75 rows)
Column A
randomly pick 1 or 2
Column B
60% 1 and 40% 2 randomly assigned to cases 1-75 (Thus, 45 1's and 30 2's randomly assigned to rows 1-75)
Column C
Randomly pick from the range of numbers 18-65. Make sure the mean for the column is 48.72.
Column D
Randomly pick from the range of numbers 1-7. Make sure the mean for the column is 5.49.
name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"> Generate random problems
In addition to data from af directory i got it must be possible to solve some home-made problems. Therefore i need to make a program that can generate new problems in Excel - likely on the same sheet used for the imported problems (another code i got).
It should be possible to specify the size of the problem, in other words the number of cities. Like the problems from the same directory. The problems i am generating have to consist of a number of cities with its x-y-coordinates. It will be useful if the program or the user sets a minimum and maximum value of the allowed x-y values so they are within a certain interval.
Do i need a very big code for this?
I have a spreadsheet with approx 11,000 rows and I would like to generate a unique 9 digit number for each line.
I know I could just put 100 000 000 and then increase that by one all the way down but I was wondering if there was any formula or code
I've got a problem with creating random numbers for a fictional portfolio. I've to have a row of random number but they have to add up to 1. Example: Need random numbers from B1-B11
under constraint: Sum(B1-B11) = 1
I tried to do it with the solver addin, but it only takes simple numbers as a constraint.
I'm working on a big sheet in which I have values like the following:
Testtest 12345
Test 134691241
Testtestest 2385.234
Test test test 235
Testtest test 14.35172'36
T.E.S.T. test test 31246
What I need, is a formula removing anything after the first space (" ") from the right side, but I cannot seem to figure a way to solve the problem. I tried using SUBSTITUDE, REPLACE, FIND, LEFT, RIGHT, IF, COUNT, LEN formulas,
I am trying to generate random numbers with the the constraint that the maximum value is 40 and the most likely value is around 40% of the maximum value. Are there any distributions (lognormal??) that would suit this requirement? Is there any way I can do this in Excel?
View 3 Replies View RelatedI have a userform for keeping records and would love to incorporate a new feature. I would want to generate a random serial number for each entry made with the userform.
View 2 Replies View RelatedI've been using excel for quite sometime but have never tried the macro system or posting VBA code so I'm wanting to get my feet wet with a little project.
I want to make a button on a sheet that when pressed generates a random number between 3 and 18, ideally it would make a new set of random numbers if pressed again.