Your assuming his numbers are sequentially numbered - I didn't make that
assumption - just used it as an example.

--
Regards,
Tom Ogilvy


"Biff" wrote in message
...
=INDEX(ROW(1:48),INT(RAND()*48+1))

Or, to make it robust against row insertions:

=INDEX(ROW(INDIRECT("1:48")),INT(RAND()*48+1))

Biff