VBA Tool to Select Random Rows in Excel


What is Random Row Selector Tool?

Random Rows Selector Tool

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.

The tool support following features:
  1. It supports Random and Stratified Sampling
  2. The tool is fully dynamic, it can support any data format in Excel
  3. The codes are written to provided fast results within minimum time
  4. Samples are marked and filtered for easy identification

What is Random Sampling?

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.

Random Rows Selector Tool

What is Stratified Sampling?

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.

Random Rows Selector Tool

Why Sampling is Important?

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:

  1. The samples must not be biased. For example, picking samples of a specific agent or country and not including other agents or countries in the samples
  2. Samples should be picked randomly and not in a specific order. For example, picking samples of a specific date instead of picking from entire month
  3. Samples should be picked with a defined rule so that it represents entire population

How Random Rows Selector Tool helps you?

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.

How to use this tool:

Step 1: Download the latest version of Random Rows Selector Tool

Step 2: Unzip the file and open

Step 3: Paste your data from which you want to pick the samples in the ‘Home’ sheet

Random Rows Selector Tool
Note:
  1. Please keep column A and B empty, these columns are used by the tool for calculations
  2. Column C should not have any empty records
  3. You are free to rename or add new columns in the sheet

Step 4: Click on ‘Open Tool’ button

Random Rows Selector Tool

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

Random Rows Selector Tool

Step 6: Tool will pick the samples from the data and filter them for you

Random Rows Selector Tool

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

Random Rows Selector Tool

Step 8: Tool will pick the samples from the data and filter them for you

Random Rows Selector Tool

Step 9: Stay tuned with Excelsirji.com for more free tools and templates

Leave a Reply

avatar
Time and Motion Study Thumbnail
FREE VBA UTILITIES
41
Time and Motion Study – Complete Guide

Here is one more wonderful free tool from ExcelSirJi.com which makes your life easy. Time & Motion Tracker helps you to track Start and End time of any type of transaction or activity. The good thing is, it is VBA based tool which helps you to protect from manual manipulation in the data by the user. It is also easy to use, just click on Start (shortcut: Ctrl+Shift+A) or Stop (Ctrl+Shft+S) buttons to record the time

VBA Code to Find Duplicate Files
FREE VBA UTILITIES
VBA Code to Find Duplicate Files

Yesterday I was working on my computer and cleaning the drives to make some more space.  I was surprised to see so many files saved at multiple places which was consuming huge space of my computer drives. One of the biggest tasks was to identify such duplicate files. Initially I …

VBA To Rename Files
FREE VBA UTILITIES
2
Excel VBA Tool to Rename Files

Here is another help code and tool for programmers to rename files. You can use this tool for renaming all files available in a selected folder. Just browse the folder and hit ‘Rename Files’ button ‘This function loops through all the files listed in the sheet and ‘rename them as …

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn