ABC Inventory Classification

[Richard]

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,

 

[akphidelt]

Highlight all your data go to Data--> PivotTable

Create a pivot table and it will do all the magic you need.