Sorting and filtering complex data (with a pivot table)

You are right. Sorry. Should have thought of that.

The file contains example source data and to the right three examples of how it should be formatted and the result of the user defining filters.

I've included two identical files for different versions of Excel just in case.

Example.xls, Example.xlsx

P.S. Having some site trouble, I hope they are attached.

Am having problems with the site, attempting to reply and attach files a second time.

Example.xlsxExample.xls