Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 29th 12, 01:28 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2012
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to update a column in a work based on another work sheet WickerMan New Users to Excel 1 December 4th 09 01:58 PM
flash object dont work in my excel work sheet Nitn Excel Discussion (Misc queries) 0 July 4th 09 08:00 AM
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 goutam Excel Programming 1 February 1st 08 08:40 AM
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? Marc Excel Programming 2 July 12th 06 04:10 AM
Counting dates in multiple work sheets and work books Savage Excel Discussion (Misc queries) 0 December 20th 05 12:41 AM


All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017