Thread: Formula Needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steven Sinclair Steven Sinclair is offline
external usenet poster
 
Posts: 21
Default Formula Needed

Here's what I have...

Purple
Blue
Red
Orange
Green

Each of the colors represent a player.
Each of the players needs a partner.
Each set of partners needs to play with another set of partners.
Each player needs to play with a different partner against all other partners.

All-in-all, we need to count how many games can be played with how many
UNIQUE partners and UNIQUE opposing partners.

I have no idea of even where to begin other than just writing everything out
by hand on a piece of paper.

Thanx.