Use the tool to get a random selection from a set of your Excel data range. It's also possible to specify the percentage and number of cells, rows, or columns you want to get from the entire selection.
Pick the option to Select Randomly from the Randomize tool, Utilities group on the Ablebits Tools tab in Excel:
The add-in offers you the following options:
Once options are chosen, click the Select button and get your datasets highlighted.
I follow these steps and nothing seems to happen except under "select randomly" the rows selected show up but they aren't filtered on the spreadsheet, not does a new tab show up with the selected rows. what am i missing?
Ok, figured out that it highlights the randomly chosen rows, but how do you get them grouped together by themselves?
Hello, Doug,
Thank you for using our tool and for your question.
Select Randomly neither filters the sheet by the selected rows, nor groups the randomly selected rows/columns/cells.
In fact, it simply selects random rows, columns, or cells (depending on the options you choose) so you could work with them as you need. If you need to get the randomly selected entries on a separate sheet, you will have to copy and paste them into a new Excel sheet manually.
Thank you.
This would be great if the cells stayed highlighted. The range changes and highlights disappear when you click back onto the spreadsheet. This makes it very difficult to filter or do anything with the randomly selected cells.
Hi, Ashlea,
Thank you for using the tool and for your feedback! Since this is quite a common request, I will pass it to our developers and hopefully, we will implement this feature in the coming releases.
Thank you.
