ExcelRaceRatings
New Member
- Joined
- Jan 9, 2016
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have a large spreadsheet containing race times from Horse Racing tracks all around Australia. I want to able to average the top 10 times sorted by: track, distance and track condition.
Using "Flem 1200 4" as an example (i use the concatenate formula to join multiple data into one column). There are 62 entries with Flem 1200 4 in A1:A62 and the race times in B1:B62. As stated above i want to be able to Average the top 10 values which fall under "Flem 1200 4" only. I need to do this for 11,000 different types of scenarios hence why i would love a formula to be able to pick the top 10 from each scenario with ease?
Would greatly appreciate any assistance!
I have a large spreadsheet containing race times from Horse Racing tracks all around Australia. I want to able to average the top 10 times sorted by: track, distance and track condition.
Using "Flem 1200 4" as an example (i use the concatenate formula to join multiple data into one column). There are 62 entries with Flem 1200 4 in A1:A62 and the race times in B1:B62. As stated above i want to be able to Average the top 10 values which fall under "Flem 1200 4" only. I need to do this for 11,000 different types of scenarios hence why i would love a formula to be able to pick the top 10 from each scenario with ease?
Would greatly appreciate any assistance!