Randomize

This is very simple, I think, but not for me. :-)

I have 90 numbers (from 1 to 90), and when I press the button, one number is
shown in cell A1. I press button for the second time, second randomized
number (but number before is excluded from randomizing) is shown in cell B1,
etc. and when is 20th nubmer shown in cell T1, 21st nuber goes to second row
in A2, next in B2...
41st in A3... and when is 90th shown next display in cell A6 "Stop".

Thanx.

How about just populating all those cells at once with one array formula.

If yes, take a look at J.E. McGimpsey's =randint() function:
http://www.mcgimpsey.com/excel/udfs/randint.html

"Davor Županić" wrote:
>
> This is very simple, I think, but not for me. :-)
>
> I have 90 numbers (from 1 to 90), and when I press the button, one number is
> shown in cell A1. I press button for the second time, second randomized
> number (but number before is excluded from randomizing) is shown in cell B1,
> etc. and when is 20th nubmer shown in cell T1, 21st nuber goes to second row
> in A2, next in B2...
> 41st in A3... and when is 90th shown next display in cell A6 "Stop".
>
> Thanx.

--

Dave Peterson