subtraction in a list of numbers that resets with a label.
I have a long list of data in a column with tags or labels at different
intervals in the list. I am trying to subtract each row from the data
point just below the lable. Then when a new label is found the list my
calculations continue but based on the value after the newly found
lable. Can that be done with functions?
For example:
label NA
1 0
3 2
7 6
9 8
label NA
5 0
9 4
15 10
17 12
|