View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Excel or database program calculation?

I posted this question earlier, but perhaps I didn't describe it properly. I
have 3 columns of data. Width, Height & Quantity (example: 45 30 13). I also
have about 500 rows of records that consist of about 50 different size
combinations. I need a total number of pieces for each size. I can go through
the 500 rows and list all the sizes, then do a calculation to give me the
total. However, it takes a very long time to go through the 500 rows. Can
Excel somehow search and find all the size combinations and list them at the
beginning or end of the table with the total of each size? Or do I need to do
this in Access or Filemaker? Thanks to all who previously tried to help me
with this problem.