The RAND function is less likely to repeat numbers than RANDBETWEEN since it generates decimals, not whole numbers. You can use the RANK function in combination with the RAND function to sort ...

Random Sort in Excel You can generate random numbers in Excel and use them in conjunction with Excel's sorting feature to have Excel randomize a list of data.