Forum Discussion
Accum Wins from Competitor-Day Table
The moderator would not let me respond in a single response to everyone who offered a solution, so I am responding to each of you individually.
Thank you for your solution, but I'd prefer not to have to rearrange the data table. I've laid it out as Grand Sumo does and my goal is to reduce the number of steps, not increase.
Ah, i wasn't looking for you to rearrange, I just didn't understand the set-up/need. now that I do, here is another option to try:
=MAP(G4:G27,H4:H27,LAMBDA(day,name,SUM(FILTER(--TAKE(B4:E9="o",,day),A4:A9=name))))But I have to ask, why that set up? Columns G & H can be auto-populated and they would be in the same order each time, or you could recreate the nice compact table in A3:E9 but show cumulative wins going across the columns. I guess I'm just wondering if we could help you more and maybe in ways you aren't even thinking. In the attached I added a tab for the above formula solution but also added examples where the whole columns G:I are auto generated in columns K:M and also recreated the compact table but showing cumulative win numbers in A11:E17
In each case these formulas are very flexible and only require the input ranges to be set and spill the rest out accordingly. I'm not saying either of these are what you want but just examples of things we can do and maybe give you ideas for how we might help you more.