Hi,

You need to have the Analysis Toolpak add-in enabled to use this formula.

Go to Tools-AddIns and enable 'Analysis Toolpak' and then try the formula.

Regards

Govind.

Raj Mazumdar wrote:
Tried that... it's only giving #NAME? as output...


"Govind" wrote:


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