Hi,
I'm a student and for a project I need to draw random 33 cells from a table of 332 values a 100 times. For that same project I needed to do that just 10 times which I did by hand, using a random value in the second column and sorting it. But it would be tiring to do 100 times.
I tried a formula like this: =index($a$2:$a$333;randbetween(2;332)) but it didn't seem to work.
If you have any suggestions, please let me know.
Bookmarks