Product | Sales | Sales% | Descending Order | Cumulative percent | What I need |
A1 | 20 | 20% | 40% | 40% | C1 |
b1 | 10 | 10% | 23% | 63% | B1 |
C1 | 40 | 40% | 20% | 83% | |
d1 | 23 | 23% | 10% |
<tbody>
</tbody>
What i need: product names who contribute maximum to entire sales. However it should only display till the cumulative percentage reaches 75%.
I want all this only with excel formula and not macros or manual methods of sorting the data through filter as i would need to change it every month as per new sale data.
Please help
Last edited: