On 10 nov, 02:51, Pete_UK wrote:
And what's wrong with formulas, Herbert?

Pete

On Nov 10, 1:46*am, Herbert Seidenberg
wrote:

Excel 2007 PivotTable
No formulas needed.http://www.mediafire.com/file/m2wjtgw0rlo/11_09_09.xlsx

Thanks for your responses

Tried both methods but not working yet.
With the formula method i get an error message #NAME
And the pivot option is not supported in Excel 2003 ?