Hey Everyone,
I was hoping that i could get your help with something.
I'm trying to create a sheet that will automatically calculate the total # of items on that list as well as then randomly assign them to another list.
I've gotten as far as doing either one separately but i would like to have the formula do one then the other in the same cell so that way not only do i have a random assignment but an equal # as well divided equally amongst the other list.
These are the formulas is this possible?
=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)
=INDEX($A$1:$A$65536, INT( (ROWS(D$3:D4) -2) * nPeople / nProducts) + 1)
Bookmarks