Posted to microsoft.public.excel.programming

Shatin[_2_] Shatin[_2_] is offline

external usenet poster

Posts: 56

random permutation of an array

Can anyone help me with a script that would shuffle the elements of an array
of integers randomly. For example:

MyArray before shuffling: 1, 2, 3, 4, 5
MyArray after shuffling: 3, 5, 4, 2, 1

I want the reordering to be really random.

TIA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Random Number Array	Ken Hudson	Excel Programming	1	June 14th 07 11:12 PM
Discrete random numbers into an array?	festdaddy	Excel Programming	4	August 21st 06 10:35 PM
permutation of values in 2 dimensional array	[email protected]	Excel Programming	1	August 21st 06 08:36 PM
random mumber array	jedg	Excel Programming	3	March 31st 06 03:43 PM
Creating a Combination or Permutation Array in Excel	D.L.	Excel Programming	4	November 1st 04 05:32 PM

All times are GMT +1. The time now is 03:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us