LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding last used mikefranklin1969 Excel Worksheet Functions 1 May 12th 06 10:05 PM
Charting Utility Usage rchacon Charts and Charting in Excel 2 May 12th 06 12:28 PM
Convert irregular data to monthly equivalent? RBW Excel Discussion (Misc queries) 3 April 2nd 06 07:50 PM
Making list of items to truck monthly usage Yarek Excel Discussion (Misc queries) 0 June 23rd 05 10:37 AM
How do I create a report to monitor monthly utilities domino Excel Worksheet Functions 1 March 5th 05 03:11 PM


All times are GMT +1. The time now is 11:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"