VBA Function that Identifies Significant Value Shifts

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am looking for a function (Flag) that identifies Significant changes
based on previous values.

Example.

Flag shows TRUE if the row value above it is 100 or more points LESS
than the previous value.

Unit---Date----------Value-----Flag
A------1/10/2006---500--------FALSE
A------1/11/2006---499--------FALSE
A------1/12/2006---399--------TRUE
A------1/13/2006---200--------TRUE
A------1/14/2006---250--------FALSE
B------1/10/2006---900--------FALSE
B------1/11/2006---925--------FALSE
B------1/12/2006---750--------TRUE
B------1/13/2006---645--------FALSE
B------1/14/2006---644--------FALSE

Any help appreciated!!!

RBollinger

.