Philip Morritt wrote:

Thanks for that but unfortunatly the random number equation is copied which
produces a new number when pasting, it runs the calculation as if hitting F9.

You want to use Paste Special / # values. That will preserve the numeric
values of the original set of random numbers. Why do you want to do this?

Regards,
Martin Brown

"Barb Reinhardt" wrote:


I'd copy and paste the first column of data so that when you recalculate,
you don't lose your numbers.
Create another column of random numbers.
=if(a1B1,"Less",if(a1<b1,"More",Equal))

"Philip Morritt" <Philip wrote in message
...

I am trying to compare a randomly generated number by the previous randomly
generated number in the same cell. I would like to know if the new number
is
higher or lower than the provious number. Once known i would like to add
up
these occurances. ie out of 100 calculations 45 were higher and 55 were
lower. 45 and 55 should be shown in the next cells. Any suggestions
would
be a great help.

Philip Morritt
University West England Bristol