View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gareth_80 Gareth_80 is offline
external usenet poster
 
Posts: 1
Default Random Number Generation & VLOOKUP

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