Forum Discussion
Question related to Formulas of 3 sheet in Formula.xlsx workbook
A 1 in the Select column indicates that this row is included in the set.
A 0 indicates that the row is not included.
The formula in D33 calculates the sum of all included shortages.
I started by entering 0 in all rows, then replaced them by 1 from the top, as described in my previous reply.
I don't understand question #2.
For question #3:
Sort the data in descending order on the shortage column.
Select the items from the top until the sum is more than 80% of the total.
Unselect the last item, then select the next one.
Etc.
You'll soon find a solution.
sir, what is SELECT column? And why we write SELECT column?
And how it will come 1 or 0?
like -
A 1 in the Select column indicates that this row is included in the set.
A 0 indicates that the row is not included.
The formula in D33 calculates the sum of all included shortages.
I started by entering 0 in all rows, then replaced them by 1 from the top, as described in my previous reply.
