Get instant live expert help on I need help with random letter and number generator

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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
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 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
I have a list of items in column A, this list can be any length whatsoever, at any time, added to or taken away from. I also have a random number generator that generates an integer between 1 and the total number of items on column A. what I then want to do is use the random number I've generated to call whatever corresponding item on the list and show it to me somewhere near the default page location. For example if I call item 315, I want whatever is in A315 to appear somewhere near the top of the page, instead of having to scroll down to A315 myself.
Solved by V. A. in 16 mins
if K6 is bigger than D246, then make a random number between 240 and 1. if not, then make a random number between K6 and 1. I need this formula in L7.
Solved by G. H. in 22 mins