S
Steved
Hello from Steved
I have cells A1:F10 with the below formula I push F9 to generate new numbers
=RANDBETWEEN(1,40)
Ok the above formula gives duplicate numbers on any row which I do not want.
What is required please so that
From A1:F1 low number to the highest as set out below
7,13,17,23,37,38 as for example and no duplicates
Thankyou.
I have cells A1:F10 with the below formula I push F9 to generate new numbers
=RANDBETWEEN(1,40)
Ok the above formula gives duplicate numbers on any row which I do not want.
What is required please so that
From A1:F1 low number to the highest as set out below
7,13,17,23,37,38 as for example and no duplicates
Thankyou.