View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OcellNuri
 
Posts: n/a
Default Finding Monthly Usage

I have been hacking away at this for a while, and I feel that I'm at a dead
end on my own, any help is greatly appreciated.

I have records of parts and the dates and quaity of usage. I am trying to
total the number of each part used for a month, and then have something like
a pivot table showing each part listed down, months listed across, and
quantity used in the data. There is a record for each time the part is used.
Here is a small sample of my data.

Part # Description
Issue Date TRL_QTY
401083 Head Stop Brush, Folder 11/9/05 3
401083 Head Stop Brush, Folder 11/13/05 3
401083 Head Stop Brush, Folder 2/13/06 8
401083 Head Stop Brush, Folder 2/13/06 -2
401115 Oven Gasket, P4
11/26/05 12
401137 Blade, Tidland Slitter System, Press 43 12/6/05 2
401138 Blade, Tidland Slitter System, Press 43 POWDER 6/1/05 2