• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

(Partial) allocation starting from the smallest value.


New Member
Hi all
I wonder if someone can help me. Attached is a simplified example of my spreadsheet. People (rows) are given certain numbers of different fruit. I know how many they've eaten. Assuming they've started from type of fruit with the lowest total and fully cleared it before starting on another type I would like my spreadsheet to show how many they've got left.
Totals won't be changing, but I have ever increasing number of rows on my report, so a solution to be able to allocate the values automatically would be greatly appreciated. Many thanks for all your help.



Excel Ninja

In B8, array-formula copied across and down :


Edit: array formula to be confirmed by pressing with CTRL+SHIFT+ENTER 3 keystrokes together instead of just ENTER