I have a random number generator between 81-88 which produces a new value
each time excel calculates.

I would like to count each time the value of the previous number generated
and the new number passes by a current value. Say 81.5. Here's my
questions...

1. Since i have to compare the previous number to the new number how do I
capture the previous number so it does not change and i can then compare it
to the new random number created?
2. How do i create an accumulator that counts the number of times the value
passes a given number say 81.5 when comparing the previous number to the
newly generated number. Again the random generator creates a number between
81-88 each time.

Thx
Dave