I would certainly go with Molby's advice on using a Pivot table for this, but we can also help you get your data into database format ready for a Pivot Table first.
ON A COPY of your workbook, and with the data as i see it in the bitmap (jpg would have been better), I would first select the whole of column C, do Edit / Go To / Special / Blanks, then do Edit / Delete / Entire Row. This will ahve gotten rid of the blank rows, but you now need to populate the blank cells in Col A, so select the whole range in Col A that corresponds to the used area in Col B, do Edit / Go To / Special / Blanks, then type = and hit the Up Arrow once and then hit CTRL+ENTER to enter this. You should now see every cell populated with the data from teh cell above. Now copy Col A and then paste special as values to get rid of the formulas. Now go ahead and create your pivot table.
A good intro to pivot tables, (and these things will truly amaze you once you get comfortable with them), is here:-
Regards
Ken.................
----------------------------------------------------------------------------
![[peace] [peace] [peace]](/data/assets/smilies/peace.gif)
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------