Randbetween with no duplicates

[SimonHughes]

Hello, is there any way of using Randbetween function without getting duplicates? I am using Excel 2016, many thanks

 

[footoo]

McGimpsey & Associates : Excel : Random Integers without repetition

 

[Peter_SSs]

If footoo's link does not satisfy your need, perhaps you could tell us more about exactly what you have and what you are trying to achieve?

 

[SimonHughes]

Hi footoo, I don't know how the logic works, but the solution works so thanks very much indeed!

 

[SimonHughes]

Hi Peter, I am just generating random lottery numbers, footoo's solution does the trick (don't know how though), many thanks.

 

[footoo]

Hi Peter, I am just generating random lottery numbers, footoo's solution does the trick (don't know how though), many thanks.

Another way is to put your lottery numbers in one column, put RAND() in the next column and fill down.
Sort the two columns by the RAND column and it will randomly sort your numbers.