I would recommend to make a Pivottable (see encl. zip-file)
Hope it helped
Ola Sandström
Zip-file:
http://www.excelforum.com/attachment...tid=3502&stc=1
-Videos about Pivottables:
http://www.datapigtechnologies.com/ExcelMain.htm-
+-------------------------------------------------------------------+
|Filename: Book4.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3502 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=379185