![]() ![]() So, if you are not happy with how your list has been randomized, keep hitting the sort button until you get the desired result. Excel RAND is a volatile function, meaning that new random numbers are generated every time the worksheet is recalculated.Įither way, Excel automatically expands the selection and sorts the names in column A as well: ![]() Or, you can go to the Data tab > Sort & Filter group, and click the ZA button. So, select any number in column B, go to the Home tab > Editing group and click Sort & Filter > Sort Largest to Smallest.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |