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.