Hi
I want to get a list of which Categories, including only the largest sums in Total, that represent about 50% of Total
Total is not sorted
The red area in Total represent roughly about 50% (at least not less) of all the numbers in Total, and includes the largest values. This area will wary. Both in number of cells and values.
Example: I want the result in E3 and down, (green area) to be like this:
20
21
22
23
24
25
26
See attached worksheet.
Hope this made sense
Bookmarks