subtraction in a list of numbers that resets with a label.
"gtslabs" wrote in message
oups.com...
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
This is only half an example: give the result you
want to get from operation.
Bruno
|