OK, I ended up with:


1. Excel sheet supplied by colleague with raw data

2. New Excel sheet linked to my coleague's sheet which has the functions I need to make a few extra columns

3. Access database links to the new sheet to give the queries I wanted

4. A 3rd Excel sheet links to the Access queries and presents the results


So this is REALLY round-the-houses, but I couldn't replicate all the Access queries in Excel with the level of knowledge I have.



At least it works!