All Questions
Tagged with random microsoft-excel
7
questions
0
votes
0
answers
42
views
How to randomize sensitve numerical data in Excel while maintaining existing data format(s) for public post? RAND each digit each cell
How to randomize sensitve numerical data in Excel while maintaining existing data format(s) for public post? This is to supply Technical Support all information (format, shape ) except confidential ...
0
votes
1
answer
30
views
trying to randomize 2 cells adding values to it randomly to every week of the month for every employee
New Bei - First line >is dates, second is days and the third is week number.
This is how my data look like. it is a weekly off register wherein I need to add word "WO" randomly in only 2 ...
0
votes
1
answer
211
views
Excel - Selecting Random Cell followed by Filling
I am trying to select a random cell from an array AND then fill down, fixing the column but letting the row remain relative. For example, I am trying to select the contents of a random cell from A1:...
- 3
0
votes
1
answer
110
views
Excel: Simulating multiple recalculations (F9) and then pasting outcome into a table
TL;DR: Want to recalculate a model based on random variables and take the result and put it in a table. What's best way to do that?
Longer Explanation:
I have a model that is built upon multiple ...
- 113
0
votes
1
answer
1k
views
Week by week random lists without repeats
Definition of problem:
I have a main list of 30 names. I want to allocate these names into 5 groups of two or three on a weekly basis so that:
Each of the 30 names is randomly allocated to each group ...
0
votes
1
answer
252
views
Random Number Help - I have a confidence, max, and min, how should I do this?
For a class project, I need to create a list of 100 randomly simulated numbers, but I am struggling with the formula. According to the homework, I know that I am 95% confident that the range of the ...
1
vote
0
answers
88
views
Excel create a random sample of movies based on release year
I have a data set of 3229 movies, and I need to create random sample of 200 movies released before 2010, and also between 2010 and 2019.
I started with the trying to do the ones for 2009 and below ...
- 11