Reordering rows randomly

[WelshGareth]

Hi,

How do I change the order of 3500+ rows at random (ending up with the same number of rows but in a different order)?

I've got a sheet with each row representing a past horse race. I've been playing with staking plans and now I've found something I like, would like to test it on different set of data - the easiest way, I think, being to totally reorder the data I've already got.

Gareth

 

[GlennUK]

Have a new column and put =RAND() in each cell of the column for the 3500+ rows, after it has finished recalculating sort your entire table on that column.

 

[WelshGareth]

Cheers Glenn

There was I thinking I'd have to get into programming and allsorts!

Much appreciated.

If you're interested, the spreadsheet is at
http://gawebstuff.mm.st/

L8r,
G