Generating random numbers in Excel is as easy as typing in the appropriate ... not whole numbers. You can use the RANK function in combination with the RAND function to sort values in a dataset.