Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding last used | Excel Worksheet Functions | |||
Charting Utility Usage | Charts and Charting in Excel | |||
Convert irregular data to monthly equivalent? | Excel Discussion (Misc queries) | |||
Making list of items to truck monthly usage | Excel Discussion (Misc queries) | |||
How do I create a report to monitor monthly utilities | Excel Worksheet Functions |