One way

Put numbers 1-100 in cells A1 to A100 (type 1 in A1, hold Ctrl and copy down
to A100)
Put "=RAND()" (no quotes) in column B and copy down

Highlight columns A& B, select SORT ... by Column B and select first 50 from
column A.

If questions are in table in Excel, you could use VLOOKUP to extract
questions.

HTH

"kwidener" wrote:

I am a Taining Coordinator for a major company. I am setting up
certification boadrs that require questioning of applicants. I have a bank
of 100 questions to choose from. I only want to ask 50. How can I get a
spread sheet that will randomly pick 50 numbers from 100 without repeating a
number?
--
kwidener