Excel: Extracting all names whose sale cumulative percentage is less than 75


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%
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


This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of June 22, 2017.


For more resources for Microsoft Excel