ABC Report

[Richard]

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.

 

[Jim May]

Try:

=LARGE(A1:A10,1) For A
=LARGE(A1:A10,2) For B
=LARGE(A1:A10,3) For C

Jim May

 

[Richard]

How does it work?

Try:

=LARGE(A1:A10,1) For A
=LARGE(A1:A10,2) For B
=LARGE(A1:A10,3) For C

Jim May