Hi,

I wanted to know how to calculate the distance between two consecutive values in excel.

So, if I have generated 1000 random variables between 0 and 1 using the RAND() function. How do I calculate the distance between two consecutive values?

Any help would be greatly appreciated.

Thank you!