When there are multiple transactions, and activities processed by large firms, it gets difficult for them to check the accuracy and quality of those data sets because it is almost impossible to monitor each transaction/activity when it comes to large data sets. Hence Data analyst uses the method of Random Sampling and they pick a few data samples as per their policy and perform the audits for them.
This helps the business to know the direction and gives the inferences about the population/data sets however Random sampling should be done by automated software or it should be logical as random sampling can be biased because of human behavior.
So Excelsirji is going to help you with this free automated utility which is easy to download on any Windows-based system
Random Row Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel.
Random sampling is a method to pick certain number of records from a population of records randomly. For example, a teacher picks 4 students randomly from a class of 20 students.
Stratified sampling is a method to pick certain number of records from each population sub-group randomly. You must be able to categorize the population in one or more stratification or classification. For example, a teacher picks 2 girls and 2 boys randomly from a class of 20 students. Here gender is the stratification method.
In the modern business, there are millions of transactions processed every day. To ensure the accuracy of the transactions, each business picks few transactions and audit them as per defined checklist or audit parameters. Picking the right samples is also a big task, you must follow basic rules to pick the samples:
This tool helps to mitigate all the issue which may occur if you manually pick the samples. And the best part is, it is truly random. Just try to use the tool and we are sure that you would love it for its simplicity and high performance.
Step 2: Unzip the file and open
Step 3: Paste your data from which you want to pick the samples in the ‘Home’ sheet
Step 4: Click on ‘Open Tool’ button
Step 5: 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
Step 6: Tool will pick the samples from the data and filter them for you
Step 7: 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
Step 8: Tool will pick the samples from the data and filter them for you
Step 9: Stay tuned with Excelsirji.com for more free tools and templates
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.
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.
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
VBA Code to list Files in Folder To work on multiple files through VBA programming, you need to have VBA code that can list files in a folder. Here is a simple code for you,…
To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the file to the function and it will check if the file exist at the location. If it returns True that means the file is available at the path, if it returns False that means it is invalid path or the file does not exist at the location.
Duplicate Data Identifier is an MS Access based tool which helps to identify duplicates from any Excel based data. The tool supports up to 10 conditions and 25 types of matching conditions to find the exact duplicate. You can also define formatting conditions to first format the data before checking for duplicates.
Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.
Outlook Bulk Email Tool is an Excel and Outlook based tool which helps you to send or draft email in bulk right from Excel. It reads the recipient details from Excel sheet and uses Outlook installed on your system to generate emails. The tool supports To, Cc, Subject, Email Body, Attachment, HTML Table in Email Body.
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.
Hi,
This tool is very useful and awesome.
Can you please provide VBA Password for better understanding.
Thank you
Hello Ankit,
Thanks for contacting ExcelSirJi team.
As you know that we at ExcelSirJi work hard to help our subscribers and visitors to make full use of the free codes and templates published by our team.
As part of our objective, you are free to use these templates. However to access the code, you may refer the below link to get unprotected version
Please visit Random Rows Selector Tool v1.0_Unprotected Version to know more about the unprotected version.
Regards,
Your Excel Mate
Hi,
Just wanted to know that the version which can be downloaded from site is a protected or unprotected version. Second can we get the VBA codes for this version.
Thanks. Archana
Thanks Archana for showing interest in the tool.
Free version is password protected and if you want to access VBA code, you need to purchase the premium version cost $6.99 for personal use and corporate use, it is $149.99. You can contact us on our email ID [email protected]. Currently purchase mode from website is off due to some technical development and that will be available soon.
Let me know should you have any questions. Have a nice day ahead.