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.

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.

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.