Hello everyone,
I'm trying to create a list of random names based on different job functions that people are trained on. So far I can do each job function separately using
=INDEX($B$15:$B$44,LARGE(IF($D$15:$D$44=$G$14,ROW($D$15:$D$44)-ROW($D$15)+1),INT(RAND()*COUNTIF($D$15:$D$44,$G$14)+1)))
but I'm having trouble when it comes to combining all of the lists. Some people are trained in multiple functions and others only in one but I don't want those that are trained in multiple functions to show up on multiple lists. Is there a way to have excel excluded a persons same in a new random list if they are already showing up in another? I'm not sure if I'm explaining this correctly but any advise would be much appreciated.
Bookmarks