the actual sheet that uses the lists is variable in size....from a1:a133
to a1:337....all dependent on how many students i have each month. the
formula was used in 4 different sheets that each contain 80+ bullet
comments for testable areas. the point was to make it so that my
instructors could not use the same bullet twice each class. if the
formula cannot do it.....any ideas?


--
static69
------------------------------------------------------------------------
static69's Profile: http://www.excelforum.com/member.php...o&userid=11075
View this thread: http://www.excelforum.com/showthread...hreadid=345855