Most valuable professional
  • Hot Topics

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

Product A1 b1 C1 d1 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 by dali1962; Today at 03:03 AM.

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel