How would you go about using the advanced filter to do this? Could you give an example of what the formulae would look like? I have tried experementing with the Pivot table but I'm not familiar with it at all.. I can't see how this will get me the results I'm looking for.

Maybe I could attach an example of the worksheet to better understand your solution?
/M