Hi Joel & Mike. Thanks for your answers, looks like I was a bit vague on what
i'm trying to achieve.
My Data is:
Column A ascending numbers 1.1 - 210.9 (but some are missing in the
sequence) Column B is a question (each one relating to a number)
Columns C, D, E & F are the 4 multiple choice answers
Column G is the Answer (A, B, C, D)

Each number relates to a checklist (ie: Checklist 1 has 5 questions,
1.1/1.2/1.3/1.4/1.5). These checklist make up various training modules - I
wanted to be able to create a look up for my team whereby they can click a
button for a module (Ie, Module 16) and have Excel automatically look up the
related checkists that make up Module 16 and create a test from the questions
- but the test to be 'random' from the number of questions per checklist. So
if checklist 1 has 5 questions, I'd only ever want 3 'random' questions
picked per test.

I thought I could use a macro to run Vlookup to break the module number
request down into checklists (this would be a simple table in another
worksheet)
The Match/Vlookup to find the related questions and finally the Random
number generator to pick 3 out of 5 matches and place them into a new
worksheet.

I'm ok on Excel but no big whizz - is this something that's a little too
complicated for the intermediate user, I would like to have a go, guessing I
just need to know where to start?

Thanks for any advice you can give me.

Kind regards

Gareth

"Mike Middleton" wrote:

Gareth -

The Discrete option of the Random Number Generation tool (part of the
Analysis ToolPak add-in) will generate static random numbers from a
specified discrete probability distribution. Click Help on the Random Number
Generation dialog box to see descriptions of the various options and how the
data must be arranged. For example, before using the Discrete option, you
should enter the values and probabilities of your discrete distribution into
adjacent columns of your worksheet, with values on the left and
probabilities on the right. And, those discrete probabilities should sum to
1.000.

You do not need to use the VLOOKUP worksheet function to obtain static
random numbers. The VLOOKUP function is sometimes used with RAND to obtain
dynamic random numbers (so you get a different set of random numbers each
time you press the F9 key).

If you need more information, please describe what results you want in more
detail. Also, describe how your data is arranged, what you are doing, and
what happens or doesn't happen.

- Mike
http://www.MikeMiddleton.com


"Gareth_80" wrote in message
...
Hi there,

I have been shown how to use the VLOOKUP function and the Random Number
Generation table to pick a random selction of questions and answers from a
data range. I keep getting the message "Numbers in discrete probability
column must have a sum of 1" but I have no idea what that means.
Unfortunately the person is no longer available and, try as I might, I
can't
find any resource to tell me (in plain English) what the fields actually
mean. Can anyone please help?

Kind regards

Gareth