Thanks so much frank. It was the last place i would look


On Wed, 27 Oct 2004 17:32:21 +0200, "Frank Kabel"
wrote:

Hi
use a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm