Not repeating random numbers

kengregau · #1 03-16-2017, 07:36 PM

Hi from Sydney, Australia.

I am designing a "tables test" for students, twenty-five multiplication questions and twenty-five division questions. It is easy to generate random numbers between 2 and 12, and thence to calculate the answers. However, I don't want to repeat the same question e.g. 2 times 8 = 16 ... I don't want that repeated later in the list.

Is there an easy (!!) way to do this, please? I have attached the current excel file for your perusal.

Thank you in advance - ken

xor · #2 03-17-2017, 10:47 AM

In columns B and D in Sheet1 I have shown a method. All the calculations are made in a new sheet, Sheet3.

Take a look and see if it is something that you can use.

kengregau · #3 03-17-2017, 01:42 PM

Thank you so very much! I've extrapolated your calculations to the other columns ... I think I have it correct now! Thanks for your help! ken

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unique Random Numbers	PomDave	Excel	1	01-12-2017 01:18 AM
How to insert random numbers that equal a certain number	baha	Excel	16	11-24-2014 10:50 AM
Filling cells with random numbers using loops? (VBA)	Sajj	Excel Programming	4	04-10-2013 02:29 PM
How to fill a cell with random numbers to do calculations?	zanat0s	Excel	1	06-13-2011 10:33 AM
Display Random Numbers as Transition	greenbutton	PowerPoint	0	03-09-2011 04:43 PM