Mar 10, 2020
Displaying random cells from a list, without duplicates?
Hello everyone!
I looked around a bit, however I don't seem to find quite the right solution for my problem.
Pretty much all I want to do is get a few random cells from a column (3 and 6 for different stuff), without any duplicates.
The way the list was selecting stuff so far was something like this:
INDEX(A$2:$A$40,RANDBETWEEN(1,COUNTA($A$2:$A$40)),1)
Which obviously would only randomly select from the list every time, without regarding whether or not there's a duplicate.
Does anyone have an idea of how to tackle this?
The way the list was selecting stuff so far was something like this:
INDEX(A$2:$A$40,RANDBETWEEN(1,COUNTA($A$2:$A$40)),1)
Which obviously would only randomly select from the list every time, without regarding whether or not there's a duplicate.
Does anyone have an idea of how to tackle this?
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Mar 10, 2020
I guess it depends a bit how you want the results laid out. If you were happy to have three unique random selections from the list arranged vertically:
=SORTN(A2:A40,3,,RANDARRAY(39),)The 3 is the number of selections, and the 39 is the length of the master list.
HTH
Adam
Original Poster Crazy Leen marked this as an answer
All Replies (2)
I guess it depends a bit how you want the results laid out. If you were happy to have three unique random selections from the list arranged vertically:
=SORTN(A2:A40,3,,RANDARRAY(39),)The 3 is the number of selections, and the 39 is the length of the master list.
HTH
Adam
Original Poster Crazy Leen marked this as an answer
Mar 10, 2020
I wasn't even aware you can fill cells through just one function in another.
I can absolutely work with it being vertically aligned, just need to move some things around.
Thank you so much!