Looking for the top 75%

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have a price list and I'm trying to pull out the items
that make up 75% of the cost (the percentage is a moving
%). Is there a function or formula other than auto filter
which would give me this information and then could the
results be copied through a formula onto another
spreadsheet and sorted in order of highest to lowest? I
was thinking MAX or Ceiling but I'm not sure if this is
the answer.

As always thanks in advance for all the help
joe
 
One possible way

=IF(ROW(1:1)<=ROUND(0.75*COUNT($A$4:$A$300),0),LARGE($A$4:$A$300,ROW(1:1)),"
")

copied down
 
The formula works perfectly for listing 75% of the total
number of items in the list. However; I appologize for
not asking correctly what I was hoping to accomplish is,
I'm trying to capture the items that help to make up ~75%
of the total dollar value of a price list. If I have 12
items and they total $125 and the dollar value associated
with each item is:
20.00 13.00 15.00 16.50 9.00 3.85 18.95 4.25
1.95 18.00 2.00 2.50
The results I need are:
20 18.95 18 16.50 15 13 (this = ~80% close enough).

Can this be done? And can it be in order of largest to
smallest value?
Thanks for your support and help
Joe
 
Back
Top