Forum Discussion
Seedling distribution
ms_mit Great you could get it to work. And what's 15 minutes for a job that would otherwise take perhaps a whole day of copying and pasting. Now that I look back at the query, I see I was over-thinking the matter by adding the Grouped Running Total. We can do without and it will probably speed up the process. See attached.
Do you want to calculate the number of bags and the number of remaining seedlings? I applied the following formulas to do this:
=SUMIFS($D$6:$D$34,$C$6:$C$34,J4,$A$6:$A$34,I4)
=ROUNDDOWN(K4/$B$3,0)
=MOD(K4,$B$3)
Could you communicate the formulas to assign bag numbers?
Hey OliverScheurich, thanks for helping
My formula for assigning bag numbers is
=COUNTIF($A$6:A6,A6)&"/"&ROUNDUP(SUMIF($I$3:$K$14,A6,$K$3:$K$14)/$B$3,0.1)
But it is just counting instances of the Farmer name. This only works until I have a bag with more than one species in it, then it breaks.
Your formulas are, I think, approaching it the other way around. The data I showed is example only. What I am trying to calculate is the lists in columns A:D. I only have the data in the base data columns I:K. Nearly 20,000 rows of it that I have to parcel out into a list like A:D.
I am sure there is a way, it's just really testing my excel skills.