Problem solved - silly error, was including the title heading.

Thanks again for your help, the formulas will save me a heap of time!

Excellent, many thanks! Got phase one working.

I'm now working on a second part: it involves pulling data from a different table, but the "lookup" data won't be exactly the same as the stored...

Hi THere

Looking for some assistance - I've had a need to use anything other than very basic formulas in Excel, but I'm now struggling to generate the information that I want.

In the attachment...

It's not an automatic background colour/shading... just when I click in a cell and start typing, it becomes highlighted. Clicking outside of the cell returns it to the standard colour.

I checked...

Screenshot of problem: http://www.equinefocus.co.uk/worderror.jpg

I create a table without problem, but when I come to type in it, the cell fills with a navy highlight, and I am unable to see the...