I'm trying to calculate the running percentage of cakes eaten by persons however, for reasons not obvious in this dummy data, the table cannot be sorted by cakes eaten.
Please see attached. In Red is my running percentage formula, that works if the table is sorted by cakes eaten. However it cannot be sorted, so I need a formula that results in the column shown green.
My aim is to automatically identify who is responsible for the top 80% of cakes eaten.
Thank you.
Bookmarks