Forum Discussion
Solved
Sortby
=SORTBY(D2:D76,RANDARRAY(LARGE(B2:B76,1))) This returns a random array based off the array in D2:D76. The original array has a possibility to contain blank cells. I do not want those blank cells t...
- Pass the array through a FILTER function:
=SORTBY(FILTER(D2:D76,D2:D76<>""),FILTER(RANDARRAY(LARGE(B2:B76,1)),D2:D76<>""))
Pass the array through a FILTER function:
=SORTBY(FILTER(D2:D76,D2:D76<>""),FILTER(RANDARRAY(LARGE(B2:B76,1)),D2:D76<>""))
=SORTBY(FILTER(D2:D76,D2:D76<>""),FILTER(RANDARRAY(LARGE(B2:B76,1)),D2:D76<>""))
I never knew a filter could be applied this way. Its something I must look into further.
This works perfectly! Thanks a bunch!