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

Selecting a random subset without repeating -- using the Sort method

The advantage of using the method described below is that changes in the random result is totally under your control. The disadvantage is that one must do a sort each time one desires a different set of results.

Suppose the group from which the selection has to be made is in A1:A11. Then, in the adjacent column, enter the formula =RAND()
Now, sort the two columns (Data \| Sort...) and pick the employees appearing at the top.

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