Random Rows Selector Tool – Unprotected Version

Random Rows Selector Tool
Random Sampling Tool

Table of Content

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:-

Random Sampling Tool

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

Follow the below video which details out how to use this tool.
  • Open the tool and you will see below screen
    Random Rows Selector Tool
  • If the macros are disabled, click on Enable Content button
    Random Rows Selector Tool
  • Delete the older data (if any) and paste your data from which you want to pick the samples in the ‘Home’ sheet
    Random Rows Selector ToolNote:
    • 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 Rows Selector Tool
  • 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
  • Tool will pick the samples from the data and filter them for you
    Random Rows Selector ToolNote: 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
Random Sampling Tool
Random Rows Selector Tool - Unprotected Version
  • Tool will pick the samples from the data and filter them for you
Random Rows Selector Tool - Unprotected Version

Note:

Excel VBA Master Tool Kit
  • 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

Recommended Articles

Random Rows Selector Tool - Unprotected Version

Similar Posts

Why use dollar sign ($) in Excel formulas
| |

Why use dollar sign ($) in Excel formulas – absolute and relative cell references

BySumit Shrimal

When creating a formula in Excel, many people get confused by the $ symbol in cell references. But it’s actually very simple. The dollar sign in an Excel cell reference tells Excel whether to keep the reference the same or allow it to change when you copy the formula to other cells. This guide will explain how it works and why it’s helpful.
Understanding Excel cell references is really important. Knowing the difference between absolute, relative, and mixed references will help you get the most out of Excel formulas and functions.

How to Use Array Function in Excel
| |

How to Use Array Function in Excel

BySumit Shrimal

In this tutorial, you’ll learn what an Excel array formula is, how to enter it properly, and how to use array constants and array functions.
Array formulas are a very powerful tool in Excel, allowing you to do multiple calculations with a single formula. One array formula can replace many regular formulas. However, most users—around 90%—have never used them because they seem intimidating to learn.
Array formulas are known to be one of the trickiest Excel features to understand. The goal of this tutorial is to make learning them as easy and simple as possible

Excel VBA Master Tool Kit