Random Selection

Infinite opportunities? Endless problems? Limited resources? Talk to us!

	Operations Consulting	Software Consulting	Publishing and Training		Applied Solutions	Excel add-ins and tutorials	Charts	Excel and VBA Case Studies	VBA tutorials	PowerPoint Add-Ins	Miscellenia

You are on the Home/Excel/Tutorials/Random Selection page

About this site

A common requirement is the selection of so many random elements without repetition from a larger group. The example used in each of the methods below is the selection of 3 employees from a group of 10. Of course, there are many more applications of this method.

There are multiple ways of doing this in Excel. Three of these are shown below.

Use the RAND() function and sort the result

Use the RAND() and RANK() functions

Use a VBA function

Keywords: random no duplicate repeat

For custom technology solutions, operations consulting, or training contact web-underscore-contact@tushar-hyphen-mehta-dot-cee-oh-em.
By accessing any page or link on this web site other than this page, you agree to the terms and conditions.

Ads from amazon.com

[Optional] Survey (current rating of site: 3.7 out of 4) If you will take a moment to provide your comments, it will help improve the site both for you, and for other visitors.

On a scale of 4 (just what I need)
to zero (totally useless)

How do you rate the information

on this page?

on this site?

[Optional]

Your name
Your email address
Other comments

Monitor page
for changes

by ChangeDetection

A comment selected at random:

Copyright © 2000-2008 Tushar Mehta.
Send comments and suggestions about the web site to webmaster@tushar-hyphen-mehta-dot-cee-oh-em
Last edited April 13, 2008