Excel RAND() and RANDBETWEEN Functions

Human being cannot consciously generate random numbers sequences as they tend to avoid/favor picking specific numbers yet there is so much application of randomness in life. Random numbers are useful in a number of ways, such as generating data encryption keys,GUIDS, Strong Passwords, selecting random samples or creating survey groups, generating lottery numbers e.t.c Scientist, […]

Generating Random Future Dates,Time & Datetime in Excel

In this article I will show you how to generate random future Dates, Time &Datetime in excel using RAND(), RANDBETWEEN and WORKDAY.INTL functions. RANDBETWEEN function returns a random integer in a range of integers. = RANDBETWEEN(bottom, top) →→bottom(smallest integer) & top (largest integer) And since excel stores date as sequential serial numbers, we can use RANDBETWEEN to generate […]

Generating Lottery Numbers In Excel

The chance of winning a lottery is usually infinitesimal but the magnitude of the rewards tends to over shadow it. This is why millions of people play or fantasize about winning the lottery daily. Since most Lottery use pseudo-random numbers to pick a winner, I will show you how you can use Excel RANDBETWEEN function to […]