Use Select Randomly 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.
On the Ablebits Tools tab, in the Utilities group, select Randomize > Select Randomly:
The add-in offers you the following options:
Once the options are chosen, click the Select button and get your datasets selected.
Is it possible to select cells according to the number of letters in each cell? I have a very long document and I would like to select all the cells that contain less than 20 letters, or alternatively cells that are too large that contain more than 100 letters?
thanks a lot.
Thank you for your question. You could consider creating a Conditional Formatting rule (-> Use a formula to determine which cells to format) based on the Excel IF and LEN functions. I hope you will find it helpful to read the following article on our blog: 'How to use LEN function in Excel to count characters in a cell'.
thanks a lot.
Is there any way to select rows randomly and then split the randomly selected that from the rest to get two separate data sets in separate sheets yet?
Thank you for contacting us. Sure, this tool will help you to select random rows but to split them you need to use another add-in. Could you please send us a small sample workbook with your source data and the result you expect to get to firstname.lastname@example.org? We will have a look and suggest a solution. Thank you.
I use this feature regularly - once the random cells are selected, use the cell "Fill color" option; this will fill all of the randomly selected cells with the selected color. You can then sort by color and cut/paste them to another worksheet. There may be an add-in that does this easier but I find this works for my needs.
Thank you for sharing your solution with us. I appreciate it!
My text box where i can manually enter my data range is not letting me type any longer. It will let me drag and select criteria, but no longer manually type in the box. is there an easy fix?
Please download and install the latest update of Ultimate Suite for Excel from this page and check if the issue occurs with the new version. If you need any further assistance, please reach us out by email, email@example.com.
In the "Select Randomly" function, is there a tracking or reference number that can be recorded per selection for documentation purposes? We use this function for random drug test selection and need to be able to document the selection.
Thank you for your question. I'm sorry but we don't quite understand your task. Can you please clarify? If you send us a sample of your workbook so that we could see your source data and the result you'd like to get to firstname.lastname@example.org, it'll help a lot. Thank you.
I have an Excel worksheet with test data for over 4,000 students. It contains a single header row followed by 4,000 rows of data.
I'd like to randomly select a sample of 10% of the student records (which I can do with your "Select random rows" option) and then have them copied to a new worksheet.
I have to copy them manually? Is that right? That is not too convenient -- have I misunderstood something (hope so!).
Thanks for your help and regards from Western Australia, Larry
Thank you for contacting us. I have just replied to you via email. Please check your Inbox. 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.
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.
Ok, figured out that it highlights the randomly chosen rows, but how do you get them grouped together by themselves?
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.
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?
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!