How Do I Randomly Select Cells In Excel

How to select cells randomly in Excel?

Supposing you have a column of values (A1: A15) in a worksheet, and now you need to select five random cells of them, how could you bargain with this? In this article, I will evidence you some tricks to select cells randomly in Excel.

Select cells randomly from a column with formula

Select cells randomly from a column with User Defined Function (UDF)

Select cells randomly from a range with Kutools for Excel

---

Select cells randomly from a column with formula

As the following screenshot shows, you have a range of data from A1 to A15, the Rand and Alphabetize formula tin can help you display the random cells in a new column. Please do as follows:

one. In the adjacent cell such as B1, enter the formula =RAND(), and press the Enter key, so copy the formula to the cell B15. And the random values will exist filled with the cells. Run across screenshot:

2. And so in the next cell over, in this case cell C1, enter the formula =INDEX($A$i:$A$15,RANK(B1,$B$i:$B$15)).

iii. So press Enter cardinal, and select the cell C1, drag the fill up handle to comprehend as many cells as desired selections. And random 5 cells of range A1:A15 take been displayed in the column C. Encounter screenshot:

---

---

Select cells randomly from a column with User Defined Function (UDF)

The following VBA code also can help yous to display random cells that you demand.

one. Click Programmer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the post-obit part into the Module:

                Function RandomSelection(aRng As Range) 'Update20131113 Dim index As Integer Randomize index = Int(aRng.Count * Rnd + 1) RandomSelection = aRng.Cells(index).Value End Office                              

2. So close the module window, and enter this function =RandomSelection($A$one:$A$15) in the cell B1. See screenshot:

three. Printing Enter fundamental, and a random value of A1:A15 has been displayed in cavalcade B. So elevate the fill handle to cover equally many cells as desired selections.

The higher up ii methods tin can display the random cell values in a new column, and they are only practical for a single column range, non work for a range of cells. Kutools for Excel'south Sort Range Randomly tool can help you select cells randomly in an original range conveniently.

---

Select cells randomly from a range with Kutools for Excel

After complimentary installing Kutools for Excel, please exercise every bit below:

ane. Select the range that you want to utilize.

2. Apply the utility by clicking Kutools > Range > Sort / Select Range Randomly, see screenshot:

3. In the Sort / Select Range Randomly dialog box, click Select button, and enter the number of the cells that yous want to select, then check the Select Blazon you need. Then click OK or Apply. See screenshot:

Select random x cells from the selected range

Select random 5 rows from the selected range

Select random 4 columns from selected range

Advanced to select random cells, Sort Range Randomly of Kutools for Excel can sort data randomly in whole range, in each rows, in each columns and so on.

randomly select or sort data in a range

---

---

Related Article:

Randomly sort cells in a column or range

---

The Best Role Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity past 80%

• Reuse: Apace insert complex formulas, charts  and anything that you have used earlier; Encrypt Cells with password; Create Mailing List and send emails...
• Super Formula Bar (hands edit multiple lines of text and formula); Reading Layout (easily read and edit big numbers of cells); Paste to Filtered Range...
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Forestall Indistinguishable Cells; Compare Ranges...
• Select Duplicate or Unique Rows; Select Bare Rows (all cells are empty); Super Find and Fuzzy Notice in Many Workbooks; Random Select...
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Bank check Boxes and more...
• Excerpt Text, Add together Text, Remove by Position, Remove Infinite; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more than; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on primal columns; Split Information into Multiple Sheets; Batch Convert xls, xlsx and PDF...
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features xxx-day gratuitous trial. 60-twenty-four hours coin back guarantee.

---

Role Tab Brings Tabbed interface to Part, and Make Your Piece of work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by l%, and reduces hundreds of mouse clicks for you every 24-hour interval!

Source: https://www.extendoffice.com/documents/excel/645-excel-select-cells-randomly.html

Posted by: kellyfamitenton.blogspot.com

Share this post