About the tool
Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in Excel.
Tool Features
- It supports Random and Stratified Sampling
- The tool is fully dynamic, it can support any data format in Excel
- The codes are written to provided fast results within minimum time
- Samples are marked and filtered for easy identification
- Access to back end VBA code
Download Automated Professionally Designed Tool given below:-
Benefits
- Pick unbiased samples
- Save time in sample picking.
System Requirements
- You need to have installed version of MS Excel 2010 or above
Tool Limitations
- As the data increases, tool may take more time to pick samples
How to use this tool
- Open the tool and you will see below screen
- If the macros are disabled, click on Enable Content button
- Delete the older data (if any) and paste your data from which you want to pick the samples in the ‘Home’ sheet
Note:- Please keep column A and B empty, these columns are used by the tool for calculations
- Column C should not have any empty records
- You are free to rename or add new columns in the sheet
- Click on ‘Open Tool’ button
- Random Selection: If you want to pick random records from the data, enter the number of records to you want to pick and click on ‘Pick Samples’ button
- Tool will pick the samples from the data and filter them for you
Note: The samples will be marked in green color to easy identification - Stratified Selection: If you want to pick random records from the data but wants to ensure that at least few records are picked from each category (such as Country). Enter the number of records to you want to pick from each category and select the category name. Once done, click on ‘Pick Samples’ button
- Tool will pick the samples from the data and filter them for you
Note:
- The samples will be marked in green color to easy identification
- In case, there are not enough records available to meet the minimum sample required then tool will pick the available records
Want to Buy this tool?
Recommended Articles
Excel VBA Course : Beginners to Advanced
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Secrets of Excel Data Visualization: Beginners to Advanced Course
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Use Automated Excel Utility Tools to increase productivity
- Quickly Move or Delete Files or Folder >> Click here
- Handle Duplicate Files with Automated Utlity >> Click here
- Generate Dummy Data For Testing >> Click here
- Excel Files and Sheets Consolidator >> Click here
- Manage Outlook Emails efficiently >> CLick here
- Send Bulk Emails wiht our Excel Automation >> Click here
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
