| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ABC Report
Does anybody know how to create an ABC report from a spreadsheet?
I have a sheet with YTD sales history for approx. 1,000 parts and would like to know which are the top sellers and should be classified as A, B, etc. Is there a formula? Please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ABC Report
Try:
=LARGE(A1:A10,1) For A =LARGE(A1:A10,2) For B =LARGE(A1:A10,3) For C Jim May in article , Richard at wrote on 5/13/08 5:03 PM: Does anybody know how to create an ABC report from a spreadsheet? I have a sheet with YTD sales history for approx. 1,000 parts and would like to know which are the top sellers and should be classified as A, B, etc. Is there a formula? Please help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ABC Report
How does it work?
"Jim May" wrote: Try: =LARGE(A1:A10,1) For A =LARGE(A1:A10,2) For B =LARGE(A1:A10,3) For C Jim May in article , Richard at wrote on 5/13/08 5:03 PM: Does anybody know how to create an ABC report from a spreadsheet? I have a sheet with YTD sales history for approx. 1,000 parts and would like to know which are the top sellers and should be classified as A, B, etc. Is there a formula? Please help. |
| 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) | |||
Hybrid Mode
