“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Need to generate a random string of numbers that do not change

Solved by V. H. in 14 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

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

Write a sub that does the following: It first generates a random winning number and stores it in a string variable (so that you can use string concatenation), and it asks the user how many cards they want to buy. It then uses a For loop to generate that number of cards and store their numbers in a card array (which should be a String array). Next, it uses a Do loop to keep checking cards until a winner has been found or no more cards remain. Finally, it displays a message stating whether you are a winner and your net gain or loss. Note that you can generate a single random digit from 0 to 9 with Excels RANDBETWEEN() function.

Solved by T. Q. in 26 mins