Drug Testing Logo
store | sign in / account | order status | contact us  

How to Randomize Data in Excel for Workplace Drug Testing

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.

How Can Excel Be Used to Maintain Randomized Data?

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.

Here’s How:

1. Open a fresh spreadsheet in Excel.

2. Enter the list of employee information either by typing it in or copy and pasting it from a separate list.

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

4. Open the randomization software (there are several available on the internet).

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

6. Now you’ll need to select a number to enter in the random controls box. If you wanted to use 50% you’d need to enter 50 and hit the limit by percent tab.

7. Click Randomize. 50% of the names on your employee list will be selected and will be put in the bottom list.

8. Click on the save list for reporting tab and save the list in a new spreadsheet. It’s best if you label it with your company name and the month and year in which you’ll be testing those employees which were selected by the randomization program. This way you know who was selected at that time and can avoid testing the same group every time

9. When you send the selected employees to the testing site and their tests results are given to you the spreadsheet you made for this month’s testing group can be opened back up. 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 record of the results and who needs to be evaluated but it also helps you remember how long it’s been between tests for each individual. This aides in the randomization process and allows you verify if an employee has had more than one positive drug testing screen.

You may have more specifications you will need to make for your own randomized drug testing plan and other factors that need to be considered in the decision and randomization process. If this is the case most companies who market randomization programs are also willing to help you plan out an individual plan that works for you. Maintaining an unbiased drug screening process is an important part of maintain a drug free environment.

Be Sociable, Share!

Tags: , , , , ,

Leave a Reply

My Account
Order Status
Contact Us
About TestCountry

Sales & Partners
Corporate Accounts
Affiliate Program
TestCountry Resources
Health & Drug Testing Information Center
Drug Slang & Street Name Search
Local Drug Testing Centers

Store Policies


Answers, comments, information, articles and opinions provided on all TestCountry related webpages are general information, and are not intended to substitute for informed professional medical, psychiatric, counseling, psychological, or other professional advice. You should not use the information on TestCountry for diagnosing or treating a health problem or disease, or prescribing any medication or other treatment. You should always speak with your physician or other healthcare professional before taking any medication or nutritional, herbal or homeopathic supplement, rehabilitation or detoxification from any substance abuse or adopting any treatment for a health or drug problem.

Shop By Category

BBB Accredited Business, Comodo Authentic Secure, Visa MC AMEX Discover

Same-day FedEx shipping available


"Thanks for your promptness in mailing my order and for the quality product. I will definitely purchase other items from you and will refer you to my friends. Thanks, again." (Dianne C.)

No items

Content Categories

Orange County Dept. of Education BBB DATIA CADCA