View Single Post
  #33  
Old 10th April 2012, 01:32 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

In an 8 horse field there are 56 different possible Box Trifecta Combinations that can occur

I have a Race with 8 greyhounds in it.
In SHEET 1 I have Column A with the Box Numbers and in Column B I have the animals names.
So A1 contains 1 and B1 contains "DOG NAME"

In SHEET 2 I want to do this.
I have written down all the 56 possible Box Trifectas - 123, 124 , 125....678
That is in Columns A,B,C
What I wish to do is have an animals name appear in a Column E when the animals Box Number is in Column A
And So with Column F and Column G.

What Formula do I put in SHEET2 E1?
and then copy that Formula through Column EFG.
Reply With Quote