View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Enrique Arredondo Enrique Arredondo is offline
external usenet poster
 
Posts: 1
Default hi,how to make the best present interchange formula for xmas

A friend is organizing a secret present interchange and I need a formula
that would tell me who gives who but duplicates not allowed. I tried using
randombetween but I get dups. How can YOu do it ? Also CAn I have
exceptions like guy A never gives to guy C ?

This is the list of guys :
ame
leo
cely
tere
richard
tamez
vero
tono
lore
viole