What version of Excel? Excel 2007 or 2010 has a really good and easy pivot table. Without looking at the data, it seems to me a pivot table is what might be needed.This might help a bit:»www.contextures.com/CreatePivotTable.html--Brian"It drops into your stomach like a Abrams's tank.... driven by Rosanne Barr..." A. Bourdain
reply to Ryno Big mistake sorryOffice 2007I'll look into the pivot table thing for now Thanks