Random number between 1 and 5 with no immediate repeat?

[HJay]

Hi,

I am attempting to make a maths worksheet that generates random maths sums but I don't want two sums in a row to have the same question (I want the same sum to appear later, just not twice in a row). Is this possible with a simple excel formula? I have been trying to put RANDBETWEEN(1,5) into an IF statement but I have not been having much luck...

 

[J.Ty.]

Hi,

Is this what you intend?

Book2
	L
1	5
2	2
3	4
4	3
5	5
6	4
Sheet2

Cell Formulas
Range	Formula
L1	L1	=RANDBETWEEN(1,5)
L2:L6	L2	=1+MOD((L1-1+RANDBETWEEN(1,4)),5)

 

[HJay]

Yes, perfect, many thanks