Had some formulas hidden away that I forgot all about until recently. If you want to sort your data by distance you might find them handy.
Works 99% of the time but because of some Betfair inconsistencies, you'll get the odd discrepancies.(Out of 830 rows I can only see 3)
Row 122 ( 1m6 NHF), which calculates to only 8f,
Row 830 Where the distance is 'Grand National' (that the year it was void maybe?)
Row 831 which is just 'PA Stks'