hi Tenny,
I suggest using a Pivot Table (PT) to summarise your data (this is just
of many possible solutions). Here is Jon Peltier's index page which has
links to a lot of useful PT reading:
'Using Pivot Tables and Pivot Charts in Microsoft Excel'
(
http://peltiertech.com/Excel/Pivots/pivotstart.htm)
including this initial explanation of what Pivot tables do:
'Using Pivot Tables in Microsoft Excel'
(
http://peltiertech.com/Excel/Pivots/pivottables.htm)
hth
Rob
--
broro183
Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile:
http://www.thecodecage.com/forumz/member.php?userid=333
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=112303