Randomize a series of numbers

[John Boice, M.D.]

How do I randomize a series of numbers within a range. Each number is
to be used only once.
For example:
Series 1 -15 entered seqentually.
Resort (unsort ) these in an random fashion so that each is used only
once.

Thanks,

John

 

[JE McGimpsey]

How do I randomize a series of numbers within a range. Each number is
to be used only once.
For example:
Series 1 -15 entered seqentually.
Resort (unsort ) these in an random fashion so that each is used only
once.

See

Random Integers without repetition
http://www.mcgimpsey.com/excel/randint.html

 

[John Boice, M.D.]

See

Random Integers without repetition
http://www.mcgimpsey.com/excel/randint.html

Many thanks.
Thant will work perfectly.

John