Using excel to work out trifectas
Dear all users
I have a table with results of race data, 1st, 2nd and 3rd from several races, from several meetings.
I have used the MODE formula to determine the most frequent winner per day, eg. out of 10 races in one day, runner No 1 came in 4 times.
I have also used the COUNTIF formula to determine how often a runner comes in. However this only gives individual results.
Is there any way to analyse the data so it will give me the combination of 3 runners which come out most frequently? Also can it be set up to account for all permutations, eg 1, 2, 3 = 2, 1, 3 = 3, 2, 1 = 1, 3, 2.
Any help would be greatly appreciated.
Last edited by MickeyB1945 : June 29th 12 at 01:31 PM
|