How to create a single sheet with all the runners and data?

[nigelk]

Re The spelling mistakes.

Looks like the problem arises when the names in col AW include an apostrophy. The formula in col AX removes these and I've changed the formula in col K to point to AX, all are reporting as ok.

It might be helpful to clean the data as much as possible after importing it. ie, check for and remove any leading/trailing spaces, and check all characters are alphabetical

Cheers,Nigel

[Laugro1968]

Thank you Nigel,

Will have a look and feedback tomorrow.

All the best,
Laurent

[Laugro1968]

Hi Nigel, Ian,

Thank you, the fomula works like a charm to match the runners now and manually eliminate non runners in the course of the day.
Regarding your spreadsheet Ian, can I ask you how to make the following adjustments
1. Having just one column headers in row 1?
2. Just have the lay - back values, without the delta calculation (only the back and lay figures)?
3. Delete empty column J (between "Low Odds" and "Last Update")?

Example below.

I ould appreciate it,
Cheers
Laurent

[Laugro1968]

Hi all,

Went through the code and it's all done. Nice and neet!

Laurent