![]() Make sure the second argument of RANDBETWEEN is greater than or equal to the number of list items and the last number that divides the ROW function has more digits than the number of list items. Type in =RANDBETWEEN(1,8)+ROW()/10000 to generate random unique numbers.Select the cell from the column that is right next to list (i.e. ![]() Copy all formulas to new cells to generate different characters for a 8-character length password (i.e.Type in =CHAR(RANDBETWEEN(33,47)) to generate a special character. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |