Joe

Visit John McGimsey's site for info on non-repeating RAND().

http://www.mcgimpsey.com/excel/udfs/randint.html


Gord Dibben Excel MVP

On Mon, 03 Jan 2005 13:12:07 -0500, Joe Blow <JoeBlow@kokomo.com> wrote:

>Hi,
>
>I have 8 cells that I want to contain a unique whole number from 1 to
>8. I don't want any of the 8 numbers to repeat.
>
>Any ideas?
>
>Joe