12/2/2023 0 Comments Random picker excel formula![]() RandomSelection = aRng.Cells(index).ValueĢ. Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the following function into the Module: Function RandomSelection(aRng As Range) The following VBA code also can help you to display random cells that you need.ġ. Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Click for full-featured 30 days free trial! Kutools for Excel's Sort Range Randomly can quickly sort or select data randomly by cells or columns or rows. Quickly Sort or select cells/Rows/Columns randomly from a selection in Excel And random 5 cells of range A1:A15 have been displayed in the column C. ![]() Then press Enter key, and select the cell C1, drag the fill handle to cover as many cells as desired selections. Then in the next cell over, in this case cell C1, enter the formula =INDEX($A$1:$A$15,RANK(B1,$B$1:$B$15)).ģ. And the random values will be filled with the cells. In the adjacent cell such as B1, enter the formula =RAND(), and press the Enter key, then copy the formula to the cell B15. Select cells randomly from a range with Kutools for ExcelĪs the following screenshot shows, you have a range of data from A1 to A15, the Rand and Index formula can help you display the random cells in a new column. Select cells randomly from a column with User Defined Function (UDF) Select cells randomly from a column with formula Supposing you have a column of values (A1: A15) in a worksheet, and now you need to select 5 random cells of them, how could you deal with this? In this article, I will show you some tricks to select cells randomly in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |