Rand Formula in Microsoft excel
RAND Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used RAND FORMULA What Does It Do ? This function creates a random number >=0 but <1. The number will change each time the worksheet recalculates, or when F9 is pressed. Syntax =RAND() Formatting No special formatting is needed. Example The following examples show how the =RAND() function has been used to randomly sort list of information. A list of cards has been entered in column C, and =RAND() in column D. By clicking inside the random numbers and then using Data, Sort or the Sort button the cards will be shuffled. The same technique has been used to generate a list of six winning lottery numbers.