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
Welcome to the forum.
In A1:A50: =RAND()
In B1 and copy down: =RANK(A1, A$1:A$50)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks