Random Sort Formula Excel Formula
where “names” is the named range B5:B11, “rand” is the named range C5:C11, and “sort” is the named range D5:D11. The RAND function generates a random value at each row. Note: RAND is a volatile function and will generate new values with each worksheet change. The second helper column holds the numbers used to sort data, generated with a formula. The formula in D5 is: See this page for an explanation of this formula....