How to Make Random Teams in Excel | Sort and Random

We gonna use two function to help us out automate that task in Excel.

The first function we are going to see is the RAND function in Excel. It returns an evenly distributed random real number greater than or equal to 0 and less than 1.

A new random real number is returned every time the worksheet is calculated.

And the second function in Excel, is the WRAPROWS function. It can provided row of values by rows after a specified number of elements to form a new array.

#JopaExcel #Dashboard #Excel