I defined the group, and tried this

=INDEX(Items,randbetween(1,COUNTA(Items)))

function, to no avail...
I'm getting the ol' #Name?


--
capnsean
------------------------------------------------------------------------
capnsean's Profile: http://www.excelforum.com/member.php...o&userid=25049
View this thread: http://www.excelforum.com/showthread...hreadid=508974