The Excel functions for generating random numbers ... not whole numbers. You can use the RANK function in combination with the RAND function to sort values in a dataset. The RANDBETWEEN function ...