I'm currently using an Index formula to randomly assign people (out of a group of 9) to work specific tasks. Here is the formula as it is now:
=INDEX($BM$3:$BM$11,RANDBETWEEN(1,10))
I'd like to step this up a bit and make it work for me a little better. I'm looking for a way to have it only assign a person if cell BJ3 is greater than zero (this number is another formula result that calculates how many of each task need to be perofrmed). So far, all of my attempts to combine an IF formula with the one above have resulted in utter failure. I'm using Office 2010 on a work computer, so I am limited as far as add-ins and other work-arounds. Any suggestions you could give for a combined or tweaked fomula would be very much appreciated!
Bookmarks