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
 
One way:

Assuming the Sum column is Column B:

C2: =IF((B2-B1)>=10,"FLAG","")

Copy down as far as necessary.
 
JE,
Thanks for your input. I am looking for a formula which would catch a
deviance of 10 over time. Your formula will indeed catch a change in 10 from
one entry to the next, but not over time. In other words the change in the
sum (by an increment of 10) might take several entries to fulfill. As in my
previous example it has taken 4 entries for the sum to change from 0 to 10,
two entries to change from 10 to 25, and two entries again to change from 25
to 14.
Any more ideas????
 
Back
Top