Flagging a particular cell?

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

As numbers are added and subtracted in a column of cells over time, the sum
of these cells changes.
I should like to discover a formula to be used which would flag a particular
cell (or point in time) when that sum fluctuates by a given amount over the
last flagged cell.
Example:

cell|data|sum|flag
1) 3 3
2) 4 7
3) -2 5
4) 5 10 FLAG
5) 6 16
6) 9 25 FLAG
7) -3 22
8) -8 14 FLAG
etc.

The formula I am looking for would examine the sum column and would flag a
variance of 10 or more from the last flagged cell.
Is this possible? Any ideas?

Thanks,
Les
____________________________________
My email address has an unnecessary E.
 
Hi
one question: How do you flag the first cell. In your example below I
don't see any algorithm for the first 'Flag' (sum: 10)?
 
Thanks for your reply Frank,
My example should have began with an initial entry of 0 (as is now shown
below). I realize subtracting one cell from the cell above will show a
change between entries, but I should like to discover a way to find the
change (in my example a change of 10 or more) when it happens regardless of
how many entries it may take?? Is this possible???
Les
 
Back
Top