Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) |