Hi,
I'm currently using the formula INDEX(UNIQUE(RANDARRAY(32,1,1,32,TRUE)),SEQUENCE(1)) to generate 32 numbers in the column of a worksheet. Works in a fashion but still produces duplicates. Does anyone know a way to avoid the duplicates? From what I can see it always involves manual interaction.
Thanks
I do not understand something...... You would like to generate 32 random numbers from pool of 32 numbers without duplicates?
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Try:
=IFERROR(LARGE(ROW($1:$32)*NOT(COUNTIF($A$1:A1, ROW($1:$32))), RANDBETWEEN(1,33-ROW(A1))),"")
copied down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
MBizarrely, it works on your attached sheet. mine kicks out dupes when i use the exact same formula in my own - :S thanks. I'll have a 2nd look to see what I'm doing wrong.
Ahh, get it, 32 numbers in random order.
Also:
Formula:
Please Login or Register to view this content.
spilled automatically.
Make sure it starts on row 2.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks