Hi Hank,

One way (and there's probably a more elegant solution):

Suppose you have five questions in your master list and want to select a
random three. In A1:A5, enter:

=RAND()

In B1:B5, enter:

=SMALL($A$1:$A$5,ROW())

In C1:C5, enter the numbers 1 through 5, or however you prefer to uniquely
identify each question in your master list.

In D1, enter:

=VLOOKUP(A1,$B$1:$C$5,2,0)

and copy/paste it down through D2:D3. Now, whenever you press F9 (or make
some data change to your worksheet), RAND() recalcs, as do SMALL and
VLOOKUP, and you'll get a different three question numbers.

Obviously, you can extend this to as many rows in columns A, B and C as you
have questions in your master list, and as many rows in column D as you want
to sample from that list.

If you want to put these formulas in rows other than those beginning with
Row 1, you'll need to make adjustments to the ROW argument to SMALL.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"hank bulger"
wrote in message
...

I need to create a formula or function that when selected, automatically
selects a random set of questions from a master list. Is this possible
in Excel? Any suggestions?:


--
hank bulger
------------------------------------------------------------------------
hank bulger's Profile:
http://www.excelforum.com/member.php...o&userid=29379
View this thread: http://www.excelforum.com/showthread...hreadid=490923