I need some help generating 6 random numbers from a list of say 25. I have tried various ways (macro, Rand and Randbetween) but keep on getting dupe numbers. Is there a way to make sure there are no dupe numbers in the list?
TIA
I need some help generating 6 random numbers from a list of say 25. I have tried various ways (macro, Rand and Randbetween) but keep on getting dupe numbers. Is there a way to make sure there are no dupe numbers in the list?
TIA
Take a look at this link for selecting from a list with no duplicates
http://www.iansharpe.com/art_excel_random.php
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks