Eric,

Do you want a Random - Program generated fight list, or do you want to
manually create one within the validation rules you have?

How many fighters from each club are there? Is it One-Vs-One, or is
it Eight-Vs-Eight (Bruce Lee Style)?

Regards


Greg

On Mar 30, 1:46 pm, "Eric" wrote:
Hello,

I am trying to write an Excel "martial art competition" program that will
populate a 8-fighter bracket from a list of fighters sorted by weight.
There are 2 requirements, weight difference between 2 fighters can't be more
than 10 pounds and they can't be from the same club (at list in the first
round).
This is not exactly an Excel technical question, but I figured that a lot of
you, Excel experts, must me faced with list sorting challenges and may have
come across resources that could help me.

Suggestions, ideas, pointers, URL's welcome... Thank you in advance.

Eric