Sorting is one of the most used features in Microsoft Excel. When it comes to horse racing excel data, it can help zone in on some potentially good horses. Excel has two types of sorting functions, ascending and descending. Ascending is when values sort from smallest to largest, e.g., 1,2,3,4,5,6 and so on. Descending is the opposite, where numbers classify from largest to smallest, e.g., 99,98,97,96 and so on.
Ok? So why is this so important when it comes to working with horse racing excel data? Let’s take the example that in our sample rating file we are looking for horses that will “Lead” when settled in the running. You may want to quickly identify all the horses across the entire race meeting for the day in each race and use them in an in-play betting strategy on Betfair. Now, if you had to do this manually, you would be clicking or browsing through some form guide or speed map in a website trying to identify each runner and who will lead in each race. In the sample horse racing excel data file, within a few seconds, you can sort by the “SET” data column that contains all the predicted settling positions of each runner. Yes, that’s right in a few seconds you have a list of runners across the entire meeting that are lead runners.
Sounds too good to be true? Well, let’s get to it and complete the steps together.