I am trying to set up a drawing - for example column A has 80 different schools, and I need to randomly select those schools in 16 slots. Of course, I don't want a school to be selected twice since they only can be selected only once.
I tried =rand() and it seems doesn't work that way.
Bookmarks