Hank, This might help.

For this example I'll assume that you have a list 50 questions and want
to select 10 of them. These numbers, 50 and 10, aren't critical.

Further assume column A has a heading in cell A1, and numbers 1 thru 50
in cells A2 through A51. These correspond to the 50 questions.

In column B, cells B2 through B51, enter the formula =RAND() to get 50
random numbers.

In cell C2 enter the formula =B2=LARGE(B:B,10), and copy it down to
cell C51.

You should get 10 TRUE values. Select those questions.


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