Using excel to work out trifectas

M

MickeyB1945

Dear all user

I have a table with results of race data, 1st, 2nd and 3rd from severa
races, from several meetings

I have used the MODE formula to determine the most frequent winner pe
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 runne
comes in. However this only gives individual results

Is there any way to analyse the data so it will give me the combinatio
of 3 runners which come out most frequently? Also can it be set up t
account for all permutations, eg 1, 2, 3 = 2, 1, 3 = 3, 2, 1 = 1, 3, 2

Any help would be greatly appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top