Thanks SteveT not sure if anyone's used it yet with no racing on , but you can download historical results from HRB, and build up I reckon maybe a years worth of data on the one sheet, then if you have any database skills at all you can pull of the days runners from HRB and get all the ratings for all the runners, if I get time I might create a simple little database to do that and post it up especially if anyone is likely to use it, handy as well that you can put in your own standard times.
Not at my PC but BX was working fine when I tested it you must have a rogue value for one of the rows in BW, what date of data did you input. HRB has little faults with the total distance Z column sometimes returning SH or HD instead of numeric , I thought I had covered this with a workaround something in the data you have obviously I must have missed something else.
I’m only guessing here but it could be you have highlighted the formulae and double clicked to copy them down, unfortunately when I was creating the sheet I had a lot if data on the sheet, so double clicking means you will get formulae in cells below your HRB data, I think this is causing the error , try dragging the formulae down to match the amount of data you have or just deleting and excess formulae below your data.
Believe me SteveT my skills are very limited I have no idea of advanced filters or pivot tables, I just wanted to create something that could be done in seconds and it’s quite basic really.O Outlander i have a few years hrb data that i will have a go with myself but i think it will be a very handy tool for anyone especially those of us with limited excel skills and the added database would be a handy tool as well. I have an excel database myself it's just a basic one but spending my free time looking at ways to improve it and just added an advanced filter to it and experimenting with a couple of pivot tables.