View Single Post
  #2   Report Post  
Bruno Campanini
 
Posts: n/a
Default 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