hi

is there a way to have excel display five random numbers between 1 to 50 without having the same number twice and the same for two numbers between 1 and 9 i already know you can use =randbetween(1,50) etc but im sometimes getting for instence 1 20 35 35 43 which i dont want

cheers