If you get a #NAME! error from the formula, it sounds as if you've typed it
wrongly.
Don't try to retype; copy the formula from the newsgroup and paste into the
formula bar of your spreadsheet.
If in doubt, copy back from your formula bar and paste here so that we can
see exactly what formula is giving you an error.
--
David Biddulph

"Toon" wrote in message
...
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 ?