| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ABC Inventory Classification
I have spreadsheet with YTD sales for approx. 1,000 parts and need to know
which items are the most important. Basically I need an ABC report which will tell me what parts make up 80%, 15% and 5% of the total Revenue and assign a letter of A, B, or C respectively. Is this possible in Excel? If so how would I do it? Thank you, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ABC Inventory Classification
Highlight all your data go to Data-- PivotTable
Create a pivot table and it will do all the magic you need. "Richard" wrote: I have spreadsheet with YTD sales for approx. 1,000 parts and need to know which items are the most important. Basically I need an ABC report which will tell me what parts make up 80%, 15% and 5% of the total Revenue and assign a letter of A, B, or C respectively. Is this possible in Excel? If so how would I do it? Thank you, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem formating cells Weine Classification Scheme for library la | Excel Worksheet Functions | |||
| Insert Row (Event Classification) | Excel Discussion (Misc queries) | |||
| Inventory Age | Excel Worksheet Functions | |||
| How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
| Change Font Color Based on Classification | Excel Discussion (Misc queries) | |||
Linear Mode
