Workplace Drug Testing BLOG

How to Randomize in Excel

In order to have a truly fair and random drug testing program, you have to be able to maintain the indiscriminate and unbiased qualities of random selection. One of the best and easiest ways to do this is to use the program Microsoft Excel to record and shuffle your list of employees for drug screening.

If you are familiar with Excel you know that it can help you with creating spreadsheets for use in accounting and recording statistics. These same aspects of the program can be used to randomly select people out of a list of employees you intend to test. With the aid of a separate randomization program, Excel will help you maintain the unbiased testing pattern you are looking for.


How Does Random Drug Testing Work?

1. Open a fresh spreadsheet in Excel.

2. Input list of employee information.

3. Save the spreadsheet. This will be the list you’ll base the random screens on.

4. Open data randomization software.

5. Click on the Open/Import tab and select your spreadsheet file. Wait for it to load. It should have imported your information into the program.

6. Select a number to enter in the Random Controls box. If you wanted to use 50%, enter 50 and hit the 'Limit by Percent' tab.

7. Click Randomize. 50% of the names on your employee list will shift to the end of the list.

8. Save list in a new spreadsheet with your company name, month and year when the drug test is performed.

Benefits of Random Drug Testing


When you send the selected employees to the testing site and their tests results are delivered, the spreadsheet you made for this month’s testing group can be reopened. The date of testing and the results can be recorded right next to their name in the list. Not only does this help you keep a record of the results and who needs to be evaluated, it also helps you remember how long it’s been between tests for each individual. This aids in the randomization process and allows you to verify if an employee has had more than one positive drug test result.

You may include additional specifications to design your own randomized drug testing policy. Maintaining an unbiased drug screening process is an important part of sustaining a drug-free environment.