I may not be wording this correctly, so am attaching a document to show illustrate. I have a column of values and I want to use a formula to identify the items that make up the top 40% of the total of the column. In the document I summed the column, calculated 40% of this, sorted high to low, then highlighted the items that would fall into this category. These are the items I want separated out (locate). If you sum these items you see they are just under the 40% of the total.
I also have a column with a percentile formula added, but it is not calculating what I want. On a very basic example the percentile function worked, so I left it there, but after using the actual figures, I'm thinking I need a different kind of formula. Any help is appreciated.
Bookmarks