Can anyone help me figuring out how I can use a formula so that I can get the result from the last row to the next one and so it adds o subtracts automatically?
I need the formula to be only working with the grouped names on the left?
Green - sum (red + red + red) = in purple but only for this group with the name on the left and so on for every person
Thanks a lot,
Sorry the column “Total Vuelo” is algo red
Could you have a look here to see if this principle applies to what you have in mind:
I guess one of your clients need to have this calculated
in two steps you have the solution. It starts with filtering out the on the Acc Name, in my example the article. This list of items FormulaMap() to get the delta
The second step is to show per row the value already see in this list of items using Slice() and Last() with an other filter that gives you the index per group of alike articles.
Let me know how it goes and if this makes sense to y…
In case it does not, what is the missing link or issue this approach won’t solve?
Thanks so much for writing.
I sort of understand but I think that formula is more advance than I am (only been here a month)
I will try it, but thanks again.
@JEC_Aviation , I can imagine you feel overwhelmed by the formulas put at work. I remember very well in the beginning that I did not understand how something could work, but felt relieved that it did work . What might help is sharing a demo doc that contains a table that looks like the official one with a column that contains hard coded the outcome you look for. This helps us to support you in finding a solution. Cheers, Christiaan
How can I share just a demo so that people only have access to that page?
if you have a team plan, you lock all the other pages
if you are on pro, you copy this page to a new doc and share this new doc with us