Get instant live expert help on I need help with random data generator
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hello, I'm conducting a statistical sample on a worksheet and from the 3000+ data points, I need to pull all of a row's contents for 51 of 3000+ identified from a random number generator (separate worksheet) my workplace uses. How do I take those 51 data points and highlight all of its rows contents (only those 51)?
Solved by O. Y. in 24 mins
I have a number generator (randbetween(1,69)) that will generate a table of 5 numbers. I am trying to eliminate previous number rows from the generator.
Solved by Z. Y. in 18 mins
I am trying to stop the arrayformula in 'Case # Generator' in columns G and H is their is no data in column B.
Solved by G. F. in 16 mins
I'm trying to create a random weighted generators based on certain criteria. On the "Magic Items" tab I have a list of things I want the tabs "Shop Generator" and "Item Generator" to pull from with weights based on their rarity from the "Prices" tab. So on the "Shop Generator" tab I want it to populate each shop based off the tab "Shops". For instance Blacksmith will generate 6 items from the tab "Magic Items" with the tags Armor, and Weapon. Then it generates a gold value for each item based on rarity from the "Prices" tab. Then it adjusts all the prices based on the shop quality in the tab "Prices"
Solved by B. B. in 13 mins
I am trying to make a random exam generator using a database of numbers with corresponding book questions. The exams 12 questions long with questions being randomly assigned by their number from the database. I have generated exams and want to print the questions to the exams by their number ID and their color. For example, I have done EXAM 1-10 by hand. How do I do this en mass?
Solved by D. J. in 21 mins