View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alen Paliska Alen Paliska is offline
external usenet poster
 
Posts: 2
Default Excel - randomization with certain criteria

I'm trying to develop a sheet that creates six random number from given list
of data. I've already found the solution for that but there are some
conditions that has to be fulfilled and I don't know how to solve it, so I
was hoping that somebody can help me.
A little explanation of the problem: on international amateur boxing
championship, computer has to automatically draw the list of 1 referee
(judge in the ring) and 5 judges (judges around the ring) from the list of
available judges, but:
1. referee and judges must not be from the countries of participants in the
ring and 2. referee can not be in the ring twice in the roll
If somebody know answer to this problem, I would appreciate it.
Thank you in advance.