On Fri, 2 Nov 2007 17:26:54 -0400, "T. Valko" wrote:

Probably, but it'll be more complicated than what I suggested already. And,
doing it that way it's not truly random. If you have 10 people then only 5
of them get to enter their name. So, now you have to have some process to
see who gets to enter their name! <g

Couldn't you generate the list once, as you originally described, pairing each
person with a randomly chosen member of the group, convert the results to a
fixed list, then when the person types their name in, it looks that name up in
column A and returns the name from column B?