Shaun


Once again mate, many thanks for sharing the excel file - I've spent a few late nights this week with Excel manual in hand getting to grips with things and your formulas will save me so much time its not funny.

One quick question for you. How do you import your data? I've done a copy and paste from VFG website and much of the data (except the race field info at the top) pastes into Excel as one column. I notice from your file (eg: rows 156 to 162) that you have evrything separated into columns which enables you to pick up info from cells such as D159 etc.

How do you achieve this? Is it using the text to columns function in Excel or do you import the data in some way that it automatically presents data in the way you want it?

Cheers

Mark