| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ABC Report
Hi,
I have a spreadsheet with the total sales for one month on items that were sold and have been asked to do an ABC report based on this info. We want to see how many items make up 80%, 15% and 5% of the total sales for the month. Then categorize those items as A, B, and C items. Is there a formula that can designate each item as an A, B, or C item? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ABC Report
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
| Print Report W/Sub Report | Excel Discussion (Misc queries) | |||
| Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
| Header in Report Manager Report | Excel Discussion (Misc queries) | |||
| =(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response | Excel Discussion (Misc queries) | |||
Linear Mode
