Celticshadow
Active Member
- Joined
- Aug 16, 2010
- Messages
- 419
- Office Version
- 365
- Platform
- Windows
Hi Forum
I am looking for an index/match formula help and am hopeful members may be able to provide a solution. I will attach breakdowns of my sheet to help with any solution that may be provided.
I obtain a report of early morning racing odds that are separated out in 15 min intervals and the report covers all the days horses and races and can extend to several thousand rows on busy racing days. What I require is to have each 15 min interval price for each horse shown horizontally and corresponding to each time the data is taken. I have attached a google docs link (Admin I do hope that is ok but I am unsure how else to attach such a large file. Thank you) as an example of what I require which I hope makes things a little clearer.
Regards
PS I have only attached a google docs link (Admin I do hope that is ok but I am unsure how else to attach such a large file. Thank you) as it is very large and am hopeful enough has been shown. As you can see at 9.00am Release the Kracken was priced at 2.34 but at 9.15am its price had moved to 2.38, also note that the horse Le Tueur was at 9.00am priced at 3.50 but at 9.15 it was priced at 3.40.
docs.google.com
I am looking for an index/match formula help and am hopeful members may be able to provide a solution. I will attach breakdowns of my sheet to help with any solution that may be provided.
I obtain a report of early morning racing odds that are separated out in 15 min intervals and the report covers all the days horses and races and can extend to several thousand rows on busy racing days. What I require is to have each 15 min interval price for each horse shown horizontally and corresponding to each time the data is taken. I have attached a google docs link (Admin I do hope that is ok but I am unsure how else to attach such a large file. Thank you) as an example of what I require which I hope makes things a little clearer.
Regards
PS I have only attached a google docs link (Admin I do hope that is ok but I am unsure how else to attach such a large file. Thank you) as it is very large and am hopeful enough has been shown. As you can see at 9.00am Release the Kracken was priced at 2.34 but at 9.15am its price had moved to 2.38, also note that the horse Le Tueur was at 9.00am priced at 3.50 but at 9.15 it was priced at 3.40.
Index Match
Sheet1 DATE,COURSE,RACE TIME,HORSE,TIME DATA TAKEN,Last Price,9.00,9.15,9.30,9.45,10.00,10.15,10.30,10.45,11.00,11.15,11.30,11.45 Release The Kraken,15 November 2022,Fakenham,12:20,Release The Kraken,9:00:00 AM,2.34,2.34,2.38,2.44 Le Tueur,15 November 2022,Fakenham,12:20,Le Tueur,9:00:00 AM,3.50...
