Hi Herbert,

Unfortunately I'm using 2003, should have said that at the beginning.
Thanks for your help though.

Regards

Andy

"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
No formula or helper needed.
http://www.mediafire.com/file/mmtzbz...02_11_10a.xlsx
.