Hi,

Use

=RANDBETWEEN(1,49)

in a cell and and copy this formula to 5 adjacent cells.

Regards

Govind.

Raj Mazumdar wrote:
Hi there

This is for a little fun... we are playing a small in-house lottery game
ourselves. Is there a way to generate 6 random numbers in the series from 1
through 49, using excel? They could either be in a single cell, separated by
commas or... separately in six adjacent cells in a row.

Thanks

Raj